I'm using wamp server but something happend into it and today there's not a way to really make it return to existence. I only get access to mysql command line, and that i possess some important databases there.

How do i export the database using commandline?

mysqldump -h localhost --routines -u root -p dbname

When the mysql server isn't acting normally, you may have some corrupted tables. It takes place usually after an unscheduled restart. mysqldump will not have the ability to export corrupted tables.

When the mysql server is running, try hooking up into it using phpmyadmin and employ the built-in tools to repair and appearance the tables

when the mysql server does not start, look into the log files and employ the mysql command line tools to repair the problems

myisamchk --silent --force --fast --update-state /var/lib/mysql/dbname/*.MYI


I believe you can easily copy the folders from the database to produce a backup of MySQL databases.

Accustomed to work.