Networks

Ask something
Discussion Locked

Importing database from MYSQL to SQL 7

0 helpful
8 replies

by mochagal 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We just bought a new company that has all its data, video, music (stuff like that) on a MYSQL (linux). We run a SQL 7.0 server.
Question: How do I import the data from MYSQL (they gave me an IP with folders that have files ending in *.dump)
I needto import these to SQL 7 server that I administer.

8 replies

by jeng

You should use mysqldump to dump out the MySQL database in SQL scripts to a text file. mysqldump is a command line utility that comes for Linux or Windows, depending on how your configuration is located. mysqldump can be used to access MySQL via TCP/IP. Check out http://www.MySQL.com/downloads for the programs.

Prior to a complete data dump, you should use mysqldump to dump out only the table schema just to make sure that SQL 7 can handle the data type and statements. MySQL doesn't completely conform to ANSI SQL and uses some of their own extensions.

by jeng

Forgot one more thing... Check with SQL 7 as I'm sure there is an interactive command line program that you can "pipe" in your text SQL dump.

This discussion is closed to new replies.