transfert all mysql database to my new server

stefane321 · 05-01-2011, 08:32 PM

Hello,

in my office i have a developpent server in fedora core so the hard drive was full

i bought a new server

noiw i would like to transfert all my database to my new server

how can i do that please?

thanks!

frankbell · 05-01-2011, 09:48 PM

Here's the short version:

Export the existing database in *.sql format.

Create a new empty database on the new server. It would be advisable to create a mysql user fill full rights to that database only, as opposed to having mysql's root administer it.

Import the *.sql file to mysql on the new server.

Here's the long version:

http://dev.mysql.com/doc/refman/5.0/...databases.html

moumoud · 05-02-2011, 10:29 AM

Try to do what frankbell say with PHPMYSQL, is very user friendly

TB0ne · 05-02-2011, 11:25 AM

Quote:

Originally Posted by moumoud

Try to do what frankbell say with PHPMYSQL, is very user friendly

...except if the OP doesn't have Apache with PHP support installed, then they'd have to set all that up (on two servers), THEN install PHPMYSQL, to use it.

Using the command line is far simpler in this case.

struct · 05-02-2011, 11:49 AM

use this command
Export:
mysqldump -h <IP> -u <user> -p<pass> <databasename> > <outputfile>

Import:
mysql -h <IP> -u <user> -p<pass> <databasename> < <outputfile

example
mysqldump -h 192.168.0.2 -u root -pmyPass database1 > database1.sql

Note: if it's innodb engine, you'll need to add --single-transaction parameter.

Then in the new system, run:

mysql -h 192.168.0.3 -u root -pmyPass database1 < database1.sql

TB0ne · 05-02-2011, 02:27 PM

Quote:

Originally Posted by struct

use this command
Export:
mysqldump -h <IP> -u <user> -p<pass> <databasename> > <outputfile>

Import:
mysql -h <IP> -u <user> -p<pass> <databasename> < <outputfile

example
mysqldump -h 192.168.0.2 -u root -pmyPass database1 > database1.sql
Note: if it's innodb engine, you'll need to add --single-transaction parameter.

Then in the new system, run:
mysql -h 192.168.0.3 -u root -pmyPass database1 < database1.sql

+1 for some very good advice.