Tilted Forum Project Discussion Community - View Single Post - Salvaging some ancient data: MySQL -> Access

bendsley · 08-31-2005, 07:43 PM

Does the machine happen to be running phpmyadmin? If so, you can export the database to a text file or whathave you.

The first step is to dump out the contents of the database running on the old server. You can do this by using the "mysqldump" command on the old server. This command will create all the sql necessary to recreate all the tables in your database, and is called a "dump". A dump can either be printed to your screen, or if there is a lot of data, the dump can be directed into to a file.

To dump your database from the old host, get a shell prompt there with telnet or ssh, and then type this all on 1 single line:

mysqldump -u DBUSER -p DBNAME > DBNAME.sql

substituting DBUSER with your MySQL username at the old host and DBNAME with your database name from the old host.

You will be prompted for your old host's MySQL password, which will not echo back at you as you type. After you provide the right password, you will have a file in your current directory called DBNAME.sql containing your entire database.

To put a MySQL database into Excel, you might try the program from the link I listed below. I don't know anything about this software, as I just found it via Google.

http://www.downloadjunction.com/prod...662/index.html

You might also look at this software too, it may seem a bit more promising.

http://www.sqlmanager.net/en/products/mysql/dataexport

08-31-2005, 07:43 PM	#2 (permalink)
bendsley Professional Loafer Location: texas	Does the machine happen to be running phpmyadmin? If so, you can export the database to a text file or whathave you. The first step is to dump out the contents of the database running on the old server. You can do this by using the "mysqldump" command on the old server. This command will create all the sql necessary to recreate all the tables in your database, and is called a "dump". A dump can either be printed to your screen, or if there is a lot of data, the dump can be directed into to a file. To dump your database from the old host, get a shell prompt there with telnet or ssh, and then type this all on 1 single line: mysqldump -u DBUSER -p DBNAME > DBNAME.sql substituting DBUSER with your MySQL username at the old host and DBNAME with your database name from the old host. You will be prompted for your old host's MySQL password, which will not echo back at you as you type. After you provide the right password, you will have a file in your current directory called DBNAME.sql containing your entire database. To put a MySQL database into Excel, you might try the program from the link I listed below. I don't know anything about this software, as I just found it via Google. http://www.downloadjunction.com/prod...662/index.html You might also look at this software too, it may seem a bit more promising. http://www.sqlmanager.net/en/products/mysql/dataexport __________________ "You hear the one about the fella who died, went to the pearly gates? St. Peter let him in. Sees a guy in a suit making a closing argument. Says, "Who's that?" St. Peter says, "Oh, that's God. Thinks he's Denny Crane."