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?

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.
OctalysAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sametcCommented:
From what I've read...  MySQLDump has a serious memory bug that allows it to consume unlimited memory until crashing...  thus providing you with no backup.

Try this command to limit it's memory usage...

ulimit -m 256000 && /usr/bin/mysqldump -e --quick --add-drop-table -Q -uuser -ppassword -r database.sql database

** The full article I read with that suggestion can be found here:
http://blog.darkscape.net/2009/12/mysqldump-consumes-all-available-memory/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tikusbalapCommented:
What kind of errors did you have?

I have millions records on database, and I managed to backup it with mysqldump within seconds.
0
OctalysAuthor Commented:
Wow, I have searched and searched on google but couldnt find the correct answer.

But this is exactly what is happening, the dump took 24hours to complete on a dual xeon ;) But it finished without memory issues now.

I thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.