-
Anonymous users2024-02-06There are many backup methods, the simplest is to use mysqldump
Backup: mysqldump -u root -p password dbname >d:
Restore: mysql -u root -p password dbname
-
Anonymous users2024-02-051.Command to back up the MySQL database.
mysqldump-hhostname-uusername-ppassworddatabasename>
2.Backing up a MySQL database is in the format with a deleted table, which allows the backup to overwrite the existing database without manually deleting the original database.
mysqldump-_add-drop-table-uusername-ppassworddatabasename>
3.Directly compress and back up the MySQL database.
mysqldump-hhostname-uusername-ppassworddatabasename|gzip>
4.Back up a table(s) in the MySQL database.
mysqldump-hhostname-uusername-ppassworddatabasenamespecific_table1specific_table2>
5.Back up multiple MySQL databases at the same time.
mysqldump-hhostname-uusername-ppassword_databasesdatabasename1databasename2databasename3>
6.Only this database structure is backed up.
mysqldump_no-data_databasesdatabasename1databasename2databasename3>
7.Back up all databases on the server.
mysqldump_all-databases>
8.Command to restore the mysql database.
mysql-hhostname-uusername-ppassworddatabasename9.It also looms over the MySQL database that is compressed by Xunyuan.
gunzip10.Transfer the database to the new server.
mysqldump-uusername-ppassworddatabasename|mysql_host=*.cdatabasename
-
Anonymous users2024-02-041. First of all, you need to select the database you want to backup, right-click and select Task-Backup.
2. The backup database window pops up and selects Add.
3. The Select Backup Destination window pops up and clicks Browse.
4. Select the directory where the backup database is stored, enter the file name, and enter the suffix. bak, click OK, and the backup is complete.
5. Right-click the database and select Restore Files and Filegroups.
6. Enter the database name in the target database column, select the source device, and click the browse option.
7. Then you need to click Add.
8. Select the database you want to restore and click OK.
9. Select the restore option and click OK to complete the restoration.
-
Anonymous users2024-02-03Put the backup file of the database in any directory on the server first, and then follow the steps below.
How to restore a backup from a backup device (Enterprise Manager).
Restore a backup from a backup device.
Server group, then server.
Databases"folder, right-click on the database, and point to"All tasks"submenu, and then click"Restore the database"Command.
In"Revert to a database"box, if the database name you want to restore is different from the default database name displayed, enter or select it there. To restore the database with a new name, enter a new database name.
DescriptionSpecifying a new name for a database automatically assigns a new name to the database files that are restored from a database backup.
Click"from the device", and then click"Select the device"。
In"Revert From", click"Tape"or"disks", and then select Restore Device.
If no device appears, click it"Add"to add an existing backup device or create a new one. In"Restore the number of dry liquid databases"dialog box, click"View content"and select the backup set you want to restore.
DescriptionThis option scans the backup set for backup content information, which can take a long time, especially if using tape devices. If you already know the backup set you want to restore, you're in"Backup number", enter the backup set number.
In"Restore the backup set", do one of the following:
Click"Database — Complete"Restore the database backup.
Click"Database – Diff"Restore a differential database backup.
Click"Transaction logs"Apply a transaction log backup.
Click"File or filegroup"Restore a file or filegroup backup. Specify the name of the file or filegroup.
Click"option"tab, and then do one of the following: (Optional).
Click"Enables the database to continue running, but other transaction logs cannot be restored", if there are no other transaction log backups to apply.
Click"Causes the database to no longer run, but restores other transaction logs"if you want to apply a different transaction log backup.
It seems that there is something called triggers in the DB, and there seems to be another thing called transactions.
MySQL exports the specified data table and data [command].
Create a database.
Select the Program Management SQL Server 2008 SQL Server Management Studio command in the Start menu to open the SQL Server Management Studio window and establish a connection using Windows or SQL Server authentication. >>>More
Let's say the textbox is named textbox and the string of numbers to be displayed is strfloat: >>>More
The database is generally composed of many tables, for example, the school builds a database, which can build a student table (including the student's name, age, student number, class, date of birth), a teacher table (including the teacher's name, age, teaching class, teaching category), a report sheet (including the student's student number, and the grades of each subject), etc. These are the ways in which the files are stored in the database, and try to make sure that the items in a table are closely related and have the same attributes, if this condition cannot be met, a table must be built (the redundancy of the built table has 4 levels). In order to meet the user's query needs, we also need to make a number of views, for example, you can make a view of his items have the name of the student, age, grades of each subject, and the teacher of each subject, etc., we can also export new items according to the existing items, for the purpose of simplicity, for example, the view can add an average grade, we add different permissions and roles to each view, and provide it to different people to query to protect the security of the database. >>>More