I want to present you a manual for maintaining the database in the Mysql manual!
Sometimes there are cases that navicat Mysql dies and never opens a database, but you don't have database backup ! And not adjustable and outputs a Mysql error!
And then what?
To score the base and reinstall all but lost?
Of course not!

So let's start!

1. We need to make sure that hidden files are visible!
(Start)---> (control Panel) ---> (folder options)!
A window will open you need the tab (View) there should be at the very bottom to find a box (Hidden folders and files) and place the circle on (Show hidden files and folders).

2. Now we need to copy the database manually.
Now open (My computer) and go to disk ( C: ) and then this path: C:Documents and SettingsAll UsersApplication DataMySQLMySQL Server 5.1data .
There you will find such L2jdb folder (or a folder with the name of your server, this is the base of your server) and the folder with the bases of your website it is also necessary to copy ( this is of course if you have a website ).
Here is the folder with database we need to copy what may be place, and then we'll go back but here :
C:Documents and SettingsAll UsersApplication Data and delete the folder MySQL!

3. The following is what we will do is remove Mysql ! (don't be afraid of the database we have retained ) !
! BUT BEFORE YOU ODALITE REMEMBER THE CHOSEN PASSWORD, WHICH YOU ONCE STOOD! (Better write it down on a piece of paper)!
Delete MySQL itself must be through:
(Start)---> (Choosing your default programs) ---> (Change or remove programs).
To find your MySQL and delete it!

4. Now we need to remove the remnants of what was left of Mysql ! (final push!)
You need to go this route:
C:Program Files ( this path may be different depending where you put the Mysql ! ) and five to delete the final folder MySQL!

5. Now there are very few! You need to put on the new Mysql!
! BUT WHEN YOU NEED TO ENTER THE PASSWORD AT THE END OF THE INSTALL, YOU NEED TO PROVIDE YOUR PREVIOUS PASSWORD WHICH YOU HAVE STOOD BEFORE! (Or you wrote down on a piece of paper)
Be sure to put Mysql on the disk where Windows is supplied as it is processed faster as it (Primary).

6. Fill base manual back!
You need to again follow the same way:
C:Documents and SettingsAll UsersApplication DataMySQLMySQL Server 5.1data .
And paste there the folder with your database, which we maintain as well as folder! ( if any ).

7. The database check.
Run Navicat and log into the database to check what comes in and then to close and launch the server!

Printer friendly version