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.