Monthly Archives: October 2015

MySQL start manually with diff user and data

If you have recently update mysql database and forgot to make a backup of old database then use following technique.

  1. Download TAR version my MySQL matching the old version
  2. untar the MySQL program
  3. stop new version of mysql server
  4. start old version of mysql using “mysqld –user=mysql –console –datadir=/usr/local/mysql-5.6.25-osx10.8-x86_64/data
  5. Now old version server is up so you can continue export databases
  6. stop mysqld
  7. start new MySQl server
  8. Restore database using newly backed up files.