CODEWITHSUNDEEP
phpmysqlsqldatabasephpmyadmin
Giovatto
Giovatto

Reputation: 77

Data Base Export Issue

Trying to clone my current wordpress site and put it on a second server to test new plugins and updating. Have been trying different methods of cloning and I keep running into a problem with the database.

I'm able to export the database from Server A in phpMyAdmin but when I go to restore it in on Server B it only gives me an empty database with the same name. All the tables and data are gone that I selected to export.

Does anyone know what I am doing wrong?

Heres how I set up the Export: Database Export

Heres how I set up the Import: Database Import

Upvotes: 1

Views: 121

Answers (2)

John D. Cook
John D. Cook

Reputation: 30089

This might help: http://support.tigertech.net/mysql-duplicate

It says you need to click on the database name on the left side before exporting, for no apparent reason, or else you won't be able to import the exported file into a new database.

Also, you have to cut your input files into small pieces. The UI says less than 50MB. In my experience, 10 MB won't work. Don't know just how big a file can be, but something less than 10 MB.

Upvotes: 0

Jason Swett
Jason Swett

Reputation: 45094

I would recommend learning how to use mysqldump on the command line, which is almost certainly what phpMyAdmin is using under the hood to do your database export. If you're using mysqldump, you can transfer the dump file via SSH (or whatever) and you won't have to deal with max upload sizes or anything like that.

In general, it's good to be proficient with low-level tools so you aren't dependent on web GUIs to do stuff.

Of course, my comments are useless if you're on shared hosting without shell access, and for all I know you already know how to use mysqldump, and you're being forced to use phpMyAdmin against your will due to hosting environment constraints.

Upvotes: 1

Related Questions