Now you must stop the MySQL service. To do so, open Control Panel and click on Administrative Tools. This is the major step that requires you to copy the backed up data folder containing the MySQL database files you want to restore to a new data folder.
In the data folder, locate the folder with the same name as the database you want to restore. But, ensure to back up the files first at a secure place before overwriting them. After copying the database files, restart the MySQL service and verify that your database is restored. For detailed information on how to repair MySQL database and tables, refer to this link. You may have to increase the value from 1—6 to start the server.
But, exceeding the value from 3 involves data loss risk. In Windows 8. Note: this is a hidden folder. It comes in handy to know this location because sometimes the MySQL Workbench fails to drop schemas or import databases. This is mostly due to the presence of files in the db folders that for some reason could not be removed in an earlier process by the Workbench. Remove the files using Windows Explorer and try again dropping, importing , your problem should be solved. Here is a sample database sakila :.
As I suspectected, they were located inside a program files folder, instead of using a proper data-only folder like most other database managers do.
Why do a my. Complicated without a shred of added benefit other than to practice touch typing. It's usually in the folder specified below, but ProgramData is usually a hidden folder.
To show it, go to control panel search for "folder" then under advanced settings tick show hidden files and click apply. Inside the data folder, each database has its own folder which in turn contains the.
If for instance, you created a database with the name: myschool and inside the database, you have three tables with the names:. Then, you will have for the Nursery table: nursery. Same will go for the Primary and Secondary tables. Thus, in the I mentioned here, you will a total of 9 files inside the database folder named myschool. I just installed MySQL 5. The my. But sometimes I see also ". Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 3 months ago. Active 4 months ago. Active Oldest Votes. You might need to copy the data also from old data directory to the new one. Improve this answer. Jotronics Computers Jotronics Computers 21 2 2 bronze badges. Ahmad Abuhasna Ahmad Abuhasna 2, 3 3 gold badges 19 19 silver badges 36 36 bronze badges. Thanks,what baffles me is that after specifying the file path in my.
This behavior I notice in Ver 8, while it was working fine while using Ver 5. Anything else I need to check? The changes done to registry as per the solution provided Step-3 in Link 2 cited in my query above. When I open Services. But if the 'datadir' points to the default drive, then the server starts immediately.
PullupSkrr PullupSkrr 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
0コメント