THE SERVER SYSTEM CRASHES AND THE DATA IS IN MYSQL, HOW DO I IMPORT IT?

As MySQL iterates over the releases, crashes become less frequent and more insidious.

In the event of a MySQL crash in production, on-site information needs to be retained for analysis. While some of the information is printed in MySQL's error log, it is often inadequate for more subtle crashes.

By enabling the operating system level, releasing user restrictions, and enabling mysql parameters, we enabled the coredump function of mysql, so that mysql crashes and leaves enough clues.

For the analysis of complex crashes, it is still necessary to hand over coredump to professional R&D engineers, or submit it to the MySQL development team.

But no matter what the scenario, if you can provide a coredump, all the techs will thank you.

I mean, I didn't back up my data, just a few hundred data files that I found in the mysql folder after redoing the server system, and I wanted to ask how do I get the forum to call these data files.

mysql is also newly installed.,I just kept the forum data in the original mysql.,The data is scattered.,Not the previous backup.。

All I have now is a few hundred data files from MySQL Data.

Changgan Xing, home Linjiujiang water (Cui Hao).

There are many ways to do this. This section describes one of them, using the ODBC driver of the MySQL database.

2.Create a database instance in MySQL.

3.Open Control Panel -- Management Tools -- Data Source ODBC, and add a MySQL ODBC data source to the user DSN.

4.Enter the data source name in the login tab, and enter mysqldns here (you can also name it yourself, as long as you select the correct data source name when importing data later); Then enter the server, user, password, enter the correct and select the database you want to import, and select the database you need to import. In Connect Options, set the port and character set used by MySQL as needed.

Note: The character set must correspond to the MySQL server, if MySQL uses the GBK character set, you must set the character set to GBK, otherwise the question mark may be garbled when imported to SQL Server.

5.Open SQL Server Enterprise Manager, select the database, right-click and select All Tasks -- Export Data.

6.Select Data Source is the default, Select Destination is the MySQL data source you just installed, and the user system DSN is MysqlDNS.

Method 2: There are many ways to do this. This section describes one of them, using the ODBC driver of the MySQL database. Steps:

2.Create a database instance in MySQL.

3.Open Control Panel -- Management Tools -- Data Source ODBC, and add a MySQL ODBC data source to the user DSN.

4.Enter the data source name in the login tab, and enter mysqldns here (you can also name it yourself, as long as you select the correct data source name when importing data later); Then enter the server, user, password, enter the correct and select the database you want to import, and select the database you need to import. In Connect Options, set the port and character set used by MySQL as needed.

Note: The character set must correspond to the MySQL server, if MySQL uses the GBK character set, you must set the character set to GBK, otherwise the question mark may be garbled when imported to SQL Server.

5.Open SQL Server Enterprise Manager, select the database, right-click and select All Tasks -- Export Data.

6.Select Data Source is the default, Select Destination is the MySQL data source you just installed, and the user system DSN is MysqlDNS.

Installation of the MySQL database server.

RAID5 only allows one disk to be disconnected, and two disks are disconnected, so you can only find a professional data recovery company to help you solve it! You can look for your local Flyer Data Recovery Center, they have very good technology!!

First go to a data company for data recovery, and then use a backup tool to back up the data and re-import it into a new machine!

Re-backup:

After the data is recovered, suppose the mysql database you originally installed is in the root directory of the c drive, then you can see that there are two folders mysql and test in the c: mysql data directory, which are the two libraries that were automatically available when the database was just installed, if you later create a new library, such as the new database named db, then you will also see another db folder here, just copy all the folders of the database you are using now, The folder contains all the tables in the database.

Database Restoration:

After reinstalling the database, you don't need to create a new database, if you still install it on the C drive, copy the folder you copied before, such as the db mentioned above, to the C: MySQL data folder, restart MySQL, the database will be automatically created, and automatically restore all the previous data!

First: the easiest way to do this is to use phpmyadmin.

Second: through the software, under Liunux, export the required database and generate a file in SQL format.

Third: The same is to use the software, under Windows, do an import operation, import the saved SQL format file, and you can do it.

You just need to change the connection to the database to the one connected to MySQL, and then redeploy your.

MySQL You need to install the MySQL database, which is the same as installing other programs, and then you put your local MySQL file, usually under the data under the MySQL installation directory; Copy it out directly, and then put it directly into the data folder of the mysql installation directory on your server, which is the easiest way; If you are not using a server and do not have absolute administrative rights over the server, you will need to use a tool like phpmyadmin to export it as an SQL file and then import it on the server.

MySQL import and export is generally limited to 20M, and the size limit can be modified by modifying the PHP configuration file.