Online Learning Academy - LearnAcad.com

... Sharing Knowledge

  • Increase font size
  • Default font size
  • Decrease font size
Home
MySQL


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

Solution:

Backup your databases first,

Read more...
 

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.

Read more...
 

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.

Read more...
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »


Page 1 of 2
Follow us on Twitter

Main Menu

Linux

Islam

Windows

Interview Questions

Database

Internet

Cisco

Entertainment

Networking

Graduate Courses

Psychology

Feed Burner

Subscribe to Welcome to Online Learning Academy by Email

Enter your email address:

Delivered by FeedBurner


Google Groups
Subscribe to LearnAcad
Email:
Visit this group

Login Form