ibdata and Database cache

iLinux85

• April 25, 2014 21:36

I have server based on Linux 64 Bit centos 6.5 and Mysql innoDB engine I created database for php script require database installation, after i successfully finished installation for first time i manually delete the database tables in /var/lib/mysql/databsename and try to re-install the php script again, the 2nd time i got problem installing the script which is tables already exist ! I restart the Mysql, delete ib_log files, the php script still recognize that there is tables exists How Could I possible clear the cache for the database to recognize that the database already have no tables ?

• 

  samachosting

  • April 26, 2014 04:32

  Are you trying to delete a database ? Why not try drop database in your mysql ?

  0
• 

  vanessa

  • April 26, 2014 05:45

  You're doing waaaay to much. Just go into cPanel and drop the database you created, or go into cPanel -> phpMyAdmin and delete all the tables inside of the database.

  0
• 

  cPanelMichael

  • April 28, 2014 12:53

  Hello :) Yes, you could simply delete the database directly through cPanel. Manually removing files associated with InnoDB is never advised unless you are a qualified system administrator and understand the consequences of such actions. Thank you.

  0

Please sign in to leave a comment.