LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   How can i copt the MYSQL Database to a other server (Database) (http://www.linuxquestions.org/questions/linux-server-73/how-can-i-copt-the-mysql-database-to-a-other-server-database-658517/)

halvorls 07-27-2008 04:44 AM

How can i copt the MYSQL Database to a other server (Database)
 
Hi!

How can i copt the MYSQL Database to a other server (Database)?

Halvor.

billymayday 07-27-2008 09:05 PM

It depends on your database type, but look into mysqlhotcopy. Otherwise you can dump the data to a text file and read it in at the other end, but the former method is simpler if supported

Quote:

mysqlhotcopy works only for backing up MyISAM and ISAM tables, and ARCHIVE tables

gilead 07-27-2008 09:06 PM

You could just tar up the directory structure and use scp to copy it over. You could also backup the database and tar/ssh the backed up data. It depends what your requirements are. The docs for backing up version 5.0 databases are here

chrism01 07-27-2008 10:19 PM

You could use mysqldump to export the db, then just import it back in, or maybe use replication (although that's overkill for a one off).


All times are GMT -5. The time now is 07:17 PM.