July 14th, 2000, 11:35 AM
Is this possible and how is it done? I'm changing servers and I want to keep the database that I already have created. Thanks in advance.
July 14th, 2000, 01:01 PM
How about making dumps of the databases (using phpMyAdmin e.g.) ?
July 14th, 2000, 01:31 PM
mysqldump --opt database > backup-file.sql
July 14th, 2000, 02:08 PM
Thanks for the ideas but I'm kinda looking for a way to do it on the MySQL command line. If that's not possible could you explain more about teh phpMyAdmin thing that you mentioned? Thanks for your qucik responses and help.
July 14th, 2000, 02:44 PM
mysqldump is command line
(a separate program that's installed when you install mysql mind you)
so instead of starting up mysql
mysqldump -u username -p databasename >backup.sql
July 14th, 2000, 03:03 PM
That's exactly what I needed. Thanks a lot.
July 15th, 2000, 12:20 PM
If you have root access, I think that you can just move the database directory in mysql's data directory from one system to another. I tried this awhile ago and it seemed to work ok.
July 15th, 2000, 04:35 PM
That *usually* works. However, if there is any version difference between the mysql servers involved you might run into a problem.