I have a huge mysql database on my comp now i want it to transfer to my friends comp. he too has mysql running
how do i do that?
Which files should i copy?
how do i do that?
Which files should i copy?
Porting mysql
You should download MySQL Front (it is free) and can be found here:
http://www.mysqlfront.de/
Anyway, with MySQL Front, you can export your databases to an SQL file, then send the SQL file to your friend, and he can use MySQL Front to import the SQL file. This way you can synchronize your DBs.
Hope that helps, enjoy!
http://www.mysqlfront.de/
Anyway, with MySQL Front, you can export your databases to an SQL file, then send the SQL file to your friend, and he can use MySQL Front to import the SQL file. This way you can synchronize your DBs.
Hope that helps, enjoy!
run mysqldump. It will be in the bin directory of your mysql installation. it dumps the data in your database. You can redirect it to a file, copy the file to other comp and import it. easy!
by the way, mysql front is NOT free! you have to $ay for it.
by the way, mysql front is NOT free! you have to $ay for it.
If you have phpmyadmin then just select the database and then go to export->select all-> and check "complete inserts", then just export
 |