Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i have crashed my server.Now is in recovery mode. I have backuped all files but i can't backup mysql tables.

From my hosting provider say that i must to start a mysql server and to backup all files. The folder is /mnt/var/lib/mysql In this folder are all database tables.

**

Hosting says: your databases are under /mnt/var/lib/mysql/. The best way is to create an chroot to /mnt, start your mysql server and use the programm mysqldump to save your databases.

**

Did anyone know how to make a full sql dump? Tnx...

share|improve this question
    
I have always just copied the databases(files) over. It always worked fine for me. –  Vick Vega Apr 11 '11 at 0:25
    
Yeah i know,but i got some errors when i upload again.Like from joomla sesions,and other things. –  DK-System Apr 11 '11 at 0:29
    
It's not a fatal errors, you can continue without issues, right? –  Vick Vega Apr 11 '11 at 3:11
    
I can't run perfectly my pages on that.I must to be sure before reinstall my server. –  DK-System Apr 11 '11 at 6:51
    
Do a simple test, download this software usbwebserver.net/en and run your test. –  Vick Vega Apr 11 '11 at 12:16

1 Answer 1

Assuming your database is started properly, the following mysqldump should grab all databases and tables. I'm also assuming you have the proper grants to do this as well.

Replace USERNAME with the username you are logging in with, and it will prompt you for your pass.

mysqldump -A --add-drop-database--add-drop-table -u USERNAME -p

share|improve this answer
    
It's say to me in putty: -bash: mysqldump: command not found –  DK-System Apr 11 '11 at 6:50
    
do a search for a command all over the filesystem: find / -name mysqldump –  Vick Vega Apr 11 '11 at 12:17
    
a better method would be 'updatedb; locate mysqldump' –  rfelsburg Apr 11 '11 at 15:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.