Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Migrating a MySQL server from one box to another

Tags:

linux

mysql

migration

The databases are prohibitively large (> 400MB), so dump > SCP > source is proving to be hours and hours work.

Is there an easier way? Can I connect to the DB directly and import from the new server?

like image 302
Brad Wright Avatar asked Mar 29 '09 16:03

Brad Wright

1 Answers

You can simply copy the whole /data folder.

Have a look at High Performance MySQL - transferring large files

like image 83
cherouvim Avatar answered Oct 11 '22 21:10

cherouvim
Sign in to Comment

Related questions

Creating an associative array from MySQL Query Results - PHP
How to retrieve multiple rows from stored procedure in MySQL?
Error when using else if in sql trigger
Fatal error: Call to undefined method DateTime::createfromformat()
MYSQL - How to workaround the row size limit of 66 KBytes
How to count items per category?
Export and import data from PHPMYADMIN
PHP Framework or not (Cake PHP)
populate a MySQL with a large series of rows quickly
syntax error on DECLARE CURSOR FOR
MySql fulltext search in PHP using string containing keywords
MySQL LOAD_FILE() loads null values
MySQL connector 6.7.4 and Entity Framework 5 exceptions
SQL Error 1064 - Import Error
Run a query foreach databases (mysql)
Why Mysql's Group By and Oracle's Group by behaviours are different
mysql stored procedure error: missing semicolon
NodeJS: Backup MySQL database
How to make MySQL use less memory?
phpMyAdmin Error in processing request Error code: 500 Error text: Internal Server Error [duplicate]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!