How to import SQL databases in XAMPP

The next graphical interface of the MSSQL management tool. A lot. You take a look. Imports are usually available in the graphical interface.

And also. Using Xampp is not as easy as apmserv. I recommend you to use this.

Xampp contains a software called phpmyadmin, with which you can import MySQL databases by opening localhost phpmyadmin. Then create a new database with phpmyadmin, click Import on the menu, select your SQL file, press OK, and you're done!

1.Use phpMyadmin in xampp to manipulate the MySQL database and export the selected database to a file.

2.Open another MySQL server and import it to the current MySQL server, follow the steps below:

a) Create Database NMS;

b) Import:

mysql -u root -p nms <;

or: the absolute path of the source;

c) Enter the password of the MySQL database to complete the operation.

To sum up a little more:

The first time you use the mysql server, there is no password, so you just use the command:

Log in to the MySQL server.

However, when using mysql in the future, it must be in the state of having a password, and use the command:

mysql -u root -p

Enter your password. to log in to the MySQL server.

In addition, the MySQL server accessed without a password is not the same as the MySQL server accessed with a password.

Method steps.

1After installing Xampp, the "Xampp" folder will appear under the directory where you installed it, which is the directory of the entire Xampp integration environment.

Let's go to this directory first, and then we'll see the executable file with the xampp flag.

2. Double-click to open, click to open Apache and MySQL, so that we can open the service, and then we can use MySQL database through the graphical interface or DOS interface, first introduce the use of DOS interface.

3. Using the DOS interface under Xampp, we can use the command to operate MySQL, and after opening the service, we can enter the DOS interface from the "shell" button in the red box in the figure to operate the database.

4After entering the DOS interface, use the command to enter the database, the root password initialized by xampp is empty, so you can enter directly without entering the password, and then you can use the database.

5 Another way is to use the Xampp graphical interface, which needs to be opened through the browser, after opening the service, we type " in the browser and then enter the home page of Xampp.

6After entering the home page, select phpmyadmin to enter the management interface.

7After entering, it looks like this, the red box on the left is the database you already have, select the database you want to use and you can enter the database for management.

8 Let's take a look at how to add a database, after clicking "Database", it will show the database you have now, you can enter the database from here to manage the data, you can also enter the name and type of the database in the red box and click "Create", a new database will be created successfully.

9After creating a database, we create a database for the database, enter the corresponding information in the red box and click "Execute", and the database is created.

10After you create **, set the properties of the column of **.

11 After setting the column properties, even if the ** is established, we can see our table in the database, and then we can add rows to **.

12Click "Insert" to add a row to **, click Browse, you can see the content in **.

Precautions. Before accessing the MySQL database, remember to enable the service.

If the password of the root user of the MySQL database is changed, phpmyadmin cannot be accessed through the web GUI to manage the database.

Attach a database or import a database.

SQL itself has data import operations. However, if you want to import data from a backup file, you need to do something else. Let's take an example.

There is already a DOE database on the SQL server, and there is a large amount of data in it, and now we are ready to import additional data from another backup file that is not the backup file of the DOE database (that is, add some data tables to the DOE after importing, and the data has been recorded in the table), and keep the data of the original DOE unchanged.

1. First, create a temporary database A1 in SQL Enterprise Manager.

2. Right-click the A1 database and select: All Tasks Restore Database.

3. In the Restore Database window, select: From Device.

4. Click "Select Device".

5. Click "Add".

6. Select the database file you want to restore from the file name, such as:

7. Click "OK" to return to the "Restore Database" window.

8. Click on the "Options" card to enter the option settings.

9. Tick the "Force restore on existing database".

10. Modify "Move to Physical File Name" to: "C: :."

11. Click OK to import the data in the backup file to the temporary database A1.

12. At this time, you can import the data from A1 to another database that you really want to import, such as the DOE database.

The following data import operations are general data import and export operations of SQL 2000 Enterprise Manager. ）

13. Select the DOE database in SQL Enterprise Manager.

14. Right-click on the DOE database and select: All Tasks Import Data.

15. In the "Select Data Source" of the DTS Import and Export Wizard window, select the temporary database A1 that you just created and imported data from the data source. Click Next.

16. In "Select Destination", the system has defaulted to the DOE database.

17. Click "Next" continuously until it is completed.

After the above operations, you have successfully imported the data in the backup file into the DOE database, and the original data in the DOE database remains unchanged.

At this point, you can delete the temporary database A1.

1.Open SQLCC

2.Connect to the database.

3.Join the table"ragnarok"(If you don't have one, you can create a new one).

4.Select the table and press Ctrl+Q

5.dot on the left"Open"Press the button (icon for a folder) to import the SQL file.

6.Delete the dark red parts (be careful to remove them all, otherwise the import process may go wrong).

7.The database at the beginning of the modification is"ragnarok", and change the username and password of the database.

8.Press on the right"Import"Press the twist (icon is an exclamation mark) to start importing.

9.Close the window when the import is complete.

10.Reconnect to the database and you'll see"ragnarok"The data table in it.

Import all the data into a temporary table in MySQL, and then use SQL statements or a process to put different data into different tables.

Explain in detail, how to quickly export and import excel data on the low** platform?