WORDPRESS MIGRATIONS

I need to migrate a huge Database Mysql in wordpress for other wordpress like "dev.website" to actual website, but the DB is largee anyone knowss how to do it ?
5 Replies
DoContra
DoContraOP2w ago
when i try to just download and upload in the other site, gives me a errors etc... if someone already deal with this kind of problem i very grateful thanks!!!!
Jochem
Jochem2w ago
generally you'd just use mysqldump with appropriate switches and then feed that into the mysql command on the other side you can split them by table with a command line argument iirc, so the entire thing isn't too big what errors are you getting?
DoContra
DoContraOP2w ago
if i split the tables dont dependency errors ???
Jochem
Jochem2w ago
iirc you can turn dependency checking off? this is all vague memories from 15 years ago like, you can turn off the enforcing of foreign key checking during import (also, you can usually import tables in the right order so that the foreign keys do resolve properly, unless there's circular references)
DoContra
DoContraOP2w ago
I will check that, thank youuu

Did you find this page helpful?