Online Learning Academy -

... Sharing Knowledge

  • Increase font size
  • Default font size
  • Decrease font size

Native table 'performance_schema'. 'file_instances' has the wrong structure

E-mail Print PDF

I am getting the following:

Native table 'performance_schema'.'file_instances' has the wrong structure
Native table 'performance_schema'.'rwlock_instances' has the wrong structure
Native table 'performance_schema'.'mutex_instances' has the wrong structure

The problem appears if you have inconsistant data or you have upgraded MySQL


Backup your databases first,


Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/html/xy

E-mail Print PDF

mysql_select_db() expects the second parameter to be a resource identifier = your connection.:

function Visit($url)
    $spyware = mysql_connect(); // set this to connect properly
    echo $url;
    mysql_select_db($database_abc, $abc) || die(mysql_error());
    // the rest of your function goes on ...



Upgrading from MySQL 5.1 to 5.5 issues and solution

E-mail Print PDF

It is good practice to back up your data before installing any new version of software. Although MySQL works very hard to ensure a high level of quality, you should protect your data by making a backup.

To upgrade to 5.5 from any previous version, MySQL recommends that you dump your tables with mysqldump before upgrading and reload the dump file after upgrading. Use the --all-databases option to include all databases in the dump. If your databases include stored programs, use the --routines and --events options as well.


MySQL table is marked as crashed and last repair failed

E-mail Print PDF

Go to your data folder and try running

service mysqld stop
myisamchk -r

You should stop MySQL process first.

If that doesn't work, you can try with

myisamchk -r -v -f




How to reset MySQL root password under Windows?

E-mail Print PDF

1. Stop your MySQL server completely. This can be done by accessing the Services window inside Windows XP and Windows Server 2003, where you can stop the MySQL service.

2. Open your MS-DOS command prompt using "cmd" inside the Run window. Inside it navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.

3. Execute the following command in the command prompt: mysqld.exe -u root --skip-grant-tables

4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.

5. Navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.

6. Enter "mysql" and press enter.

  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »

Page 1 of 2
Follow us on Twitter

Main Menu




Interview Questions






Graduate Courses


Feed Burner

Subscribe to Welcome to Online Learning Academy by Email

Enter your email address:

Delivered by FeedBurner

Google Groups
Subscribe to LearnAcad
Visit this group

Login Form