• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • Last Modified:

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.
0
Octalys
Asked:
Octalys
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now