I am getting tired of this, I am trying to dump a mysql database on an offline server but it ALWAYS fail. I know its huge but mysqldump fails miserably. Anyone know how I can dump it into a .sql file?
My situation is this, I have backupped a whole mysql directory and moved to a new server. Now I want to mysqldump it, so i can import it. Its a really huge database with A LOT of tables.
Every MySQLdump syntax i tried it somehow always fail. Mostly memory problem.
There must be an easier way to dump this database? Been trying for over a month with different kinda of methods. Please help, thank you.