mysql table does not exist

mysql table does not exist

Mysql table does not exist, but it is there. I can see it when I run show databases. Did you manually move your database instead of export and import? Chances are your are using InnoDB tables in your database. If you did, please continue and we might solve the mysql table does not exist issue.

mysql table does not exist

Take a backup of your existing mysql files. Then try to copy over the files starting with ib. Should be at least one ibdata and ib_logfile. Dump all the data with mysqldump, and you can now go ahead and restore the mysql data. Meaning you can copy your other set of ib files back (the ones you backed up). Import the data dumped with mysqldump. You should now have all your databases back in place.

mysql table does not exist – Clean up

Since you copied your database files, the owner of the files belongs to the user used for the copy. Unless you already did, change the ownership back to mysql.
chown mysql:mysql /dabase_directory -R

Also check the permissions against the other permissions. You probably need to change it back to 660.
chmod -R 660 /database_files

Restart your MySQL service

To make sure everything is catched up with your MySQL server, restart the MySQL server.
service mysql restart

See if that didn’t work.

Happy databasing!

About Author

Related Posts

mysql double vs float

MySQL: Double vs Float

When it comes to mysql double vs float to storing numbers with decimal places in a database, two of the most commonly used data types in MySQL…

Mono Develop – Use .net MySql connector

A short example on how to use the .net MySql connector with Mono Develop.First you need to make it available to your project.Go to Project -> Edit…

Mono Develop (Linux) – Install .net MySql Connector

Here is how to install a .net MySql connector for Mono Develop for Linux (Tested for Debian Variants). First we is going to download the connector, and…

Debian & Ubuntu – Recovering MySQL root password

Haven’t needed to reset my MySQL root passwords yet, but I suspect someday…. On a Debian based system this is easy and also demonstrate the importance of…

MySQL – Create database and user with permissions

Handy to know when installing WordPress, phpBB or any other fancy web applications requiring a database. First log on to your MySQL server (assuming root user is…

Debian – Basic LAMP

Setup a basic LAMP, enables you to host cool web applications. LAMP is Linux, Apache, MySQL & PHP (guess Perl or Python should qualify as well). I…

Leave a Reply