Wordpress Migration using Easy Engine

My site is currently hosted on Bluehost Optimized for wordpress hosting, I wanted to move it on Digitalocean vps.

I created a droplet using UBUNTU 14.04

Then installed Easyengine with Wordpress and w3tc.

I successfully restored the wp-content folder.

But when I am trying to restore the database I am getting the following error.

ERROR: ASCII ‘\0’ appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII ‘\0’ is expected. Query: ‘’.

@ajinkyathete

give me output for command

file mysql_dump_file

mysql_dump_file: ERROR: cannot open `mysql_dump_file’ (No such file or directory)

@ajinkyathete

Hey, Its my bad, i forgot to tell you

replace that mysql_dump_file with your mysql database backup file name you have taken from phpmyadmin.

and give me the output.

I did not get you, can you please explain. Thanks

funnytur_ajinkya.sql: ERROR: cannot open `funnytur_ajinkya.sql’ (No such file or directory)

@ajinkyathete, Please run that command inside folder where you kept your mysql dump

I am getting wordpress installation page when I am changing the db in wp-config file.

Below are the steps I am doing but failing constantly. Please tell me what I am doing wrong.

created db using following commands…

mysql -u root -p

CREATE DATABASE db_name;

grant all privileges on db_name.* TO “db_user”@“localhost” identified by “password”;

FLUSH PRIVILEGES;

exit

Then using this command to restore back up database…

mysql -h localhost -u database_user -p database_name < backup_db.sql


the back up db file is stored in var/www/example.com

and then changing the db name and user from wp-config…


@ajinkyathete

do you have mysql dump of your site with you??? Then let us know extension for that file. i.e .sql or .sql.gz

And another thing, if you are using EasyEngine you don’t need to create database; so keep that wp-config file created by easyengine unchanged.

Ya I have it, the extension is .sql.gz

@ajinkyathete

then uncompress this file using gunzip -d mysqldumpfilename.sql.gz

here filename mysqldumpfilenale.sql.gz is your mysql dump file.

Hello @ajinkyathete

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile: