MySql Information

From Kb

Jump to: navigation, search

Contents

Other Articles

  • Article on MySql Configuration [here ]

Resolving MySql Wordpress Errors

  • If 'Repair Table' option in phpMyAdmin does not fix the error
  • Stop MySql and Apache (Httpd) using scripts in /etc/init.d
  • MySql Database files are found in : /var/lib/mysql
  • Recover data using table name: myisamchk --safe-recover table_name.MYI


Command line Start and Stop

To start MySQL server service from the command line: Net start mysql

Command Line Backup

This is easier if you selected 'add MySql to Path' option when installing mysql - it means that you can go to the directory where you want to backup / restore.

MySqlDump format is not compatible with the MySqlAdministrator format (GUI Tool available from MySql that, amoung other things, allows you to backup / restore. However, MySqlDump is easier to automate!

  • Backup
    • mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
  • Restore
    • mysql -u [username] -p [password] [database_to_restore] < [backupfile.sql]
  • Alternative Restore
    • run the backupfile.sql in the MySql Query Browser (or other similar tool)
Retrieved from "http://www.firstpartners.net/kb/index.php/MySql_Information"
Personal tools