Updated XAMPP with MySQL, all my tables are missing
        Posted  
        
            by 
                user371699
            
        on Server Fault
        
        See other posts from Server Fault
        
            or by user371699
        
        
        
        Published on 2013-11-04T00:01:00Z
        Indexed on 
            2013/11/04
            3:56 UTC
        
        
        Read the original article
        Hit count: 540
        
mysql
|upgrade-issue
I just updated XAMPP to a newer version, which included updating MySQL from 5.5 to 5.6. Using phpMyAdmin, however, all of my tables within my databases still appear on the left navigation panel, but the main window shows that all my databases are empty (except for information_schema, and a couple other default tables.) Clicking on a table in the navigation panel gives me a "table doesn't exist" message. It does looks like information_schema.tables doesn't have my tables, either.
Can anyone assist me with this? I did make a complete backup of all my databases before the upgrade, but I first want to see if I can fix this the "normal" way. Furthermore, I'm not sure if the MySQL upgrade involved making changes to the information/performance databases, so I don't know if I can restore the old ones.
Thank you.
EDIT: Continuing my searching, I realized that only the INNODB databases are missing. I've tried running the following with no avail:
/opt/lampp/bin $ sudo ./mysql_install_db --basedir=/opt/lampp
and
/opt/lampp/bin $ sudo ./mysql_install_db --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql
The my.cnf file in /opt/lampp/etc contains the following InnoDB settings:
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
# Deprecated in 5.6
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
What could possibly be wrong? Why is the information_schema not updating correctly? It looks like /opt/lampp/var/mysql has all my tables in it within the database directories, but they're still not showing up in information_schema.
© Server Fault or respective owner