: Moving MySQL database to another server I have a website build using Q2A engine Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes
I have a website build using Q2A engine
Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes only.
I've copied all the files and exported the website (about 28MB raw SQL / 8MB .gz file), but when I'm trying to import it on a new server I get the error:
SELECT USER(
);
MySQL returned error: #2006 - MySQL server has gone away
What could go wrong?
I've tried several methods: importing raw sql file, gz file, importing on clean database, import on top of installed fresh copy of q2a etc... always the same error.
More posts by @Rivera981
3 Comments
Sorted by latest first Latest Oldest Best
For complete DB backup, make sure that all store procedures and functions are exported with SQL dump or export.
Use the following command to backup and restore database routines.
Step 1:
mysqldump -u mysql_user -p --no-create-db --no-create-info --no-data --routines
source_db_name > dump.sql
Step 2. Restore dump on target database:
mysql -u mysql_user -p user_password
target_DB_name < dump.sql
First perform:
Mysqldump --all-databases > all.sql
Then do:
mysql < all.sql
OK I managed to get it work. I chopped the sql export and exported separately: the structure (1 file) and the data up to 5 tables at a time.
Importing the data on a new server in such pieces returned no error.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.