Can anyone tell me how to create a back of my database. Because i dont know what is happening to my site. My data base has been damaged two times in 2 days. Please tell me the solution.
Printable View
Can anyone tell me how to create a back of my database. Because i dont know what is happening to my site. My data base has been damaged two times in 2 days. Please tell me the solution.
Before any changes you make, it is recommended to backup your data. In Magento, you can use a native backup tool in Backend » System » Tools » Backups. Here click the Create Backup button and wait for a while - the tool is now copying the data from your web-store database to your local database. Magento backup file appears in /var/backup/ after the procedure.
What database type you are using - MySQL, MSSQL, PostgreSQL, another ... ? What hosting plan do you have ?
If You are using MySQL for databse then use command: mysqldump
usage : mysqldump "databasename" -u "user name" -p > mysql.sql
The above command will import your SQL into the output file
If you use ftp to changes in website, copy data before changes.
Backup data is only to save previous data.
Are you using mysql or some other db?
Can't really help you without knowing the specific kind of database you're using.
To backup the database in mysql use the following syntax
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
Have you tried drop box? Dropbox can be a good choice, that can help you back up your files and others.
Try WPvivid backup plugin. It allows you to create backups for database and site files as well as entire website.
Open the information that you wish to form a backup copy and do the following:
1.Click File, and so click Save As.
2.Under File varieties, click Save information As.
3.Under Advanced, click make a copy information, and so click Save As.
4.In the Save As window, within the File name box, review the name for your information backup.You can modification the name if you wish, however the default name captures each the name of the first information file and also the date that you just create the backup.
5.Select the file kind you wish the backup information to be saved as from the Save as kind list, and so click Save.
Sory, can,t help you
1.Open SQL Server Management Studio Express and connect to the SQL server.
Expand Databases.
2.Right-click on the database you want to back up, then select Tasks > Back up.
3.On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
4.Select the Backup Type. By default, it is Full - leave it set to that.
5.Click Remove to remove the default/last backup file name.
6.Click Add to open the Select Backup Destination window.
7.Click [...] next to the File Name field.
8.On the Locate Database Files window, select the folder where you want to backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
9.In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
10.Click OK to close the Locate Database Files window.
11.Click OK to close the Select Backup Destination window.
12.Click OK to start the backup. The progress icon displays in the lower left corner, and a ‘completed successfully’ message displays when its done.
Open the database for which you want to create a backup copy and do the following:
1. Click "Save As"
3. Under File Types, click Save Database As.
4. Under Advanced dropdown, click Back Up Database & Save As.
4. In the Save As dialog box, in the File name box, review the name for your database backup.
5. You can change the name if you need, but the default name captures both the name of the original database file and the date that you make the backup.
6. Select the file type from the Save as type list, and then click Save.
Thanks to share the important Information.
Click File, and then click Save As.
Under File Types, click Save Database As.
Under Advanced, click Back Up Database, and then click Save As.
In the Save As dialog box, in the File name box, review the name for your database backup
Are you using cPanel? if so it's easily done https://documentation.concrete5.org/...and-phpmyadmin
Click File, and then click Save As.
Under File Types, click Save Database As.
Under Advanced, click Back Up Database, and then click Save As.
In the Save As dialog box, in the File name box, review the name for your database backup.
Creating A Backup
The mysqldump command is used to create textfile “dump” of a database that can be managed by MySQL. These database dumps are simply text type files containing all the SQL commands needed to recreate the database from scratch. The process truly is quick and easy.
Backing Up a Single Database
If you want to back up a single database, you merely create the “dump” (aka make a backup) and send the output of the “mysqldump” command into a .sql file. Don’t worry, this command doesn’t affect the database in any way; It merely makes a copy of the database.
Click File, and then click Save As.
Under File Types, click Save Database As.
Under Advanced, click Back Up Database, and then click Save As.
In the Save As dialog box, in the File name box, review the name for your database backup.
Right click on the database name.
Select Tasks > Backup.
Select "Full" as the backup type.
Select "Disk" as the destination.
Click on "Add..." to add a backup file and type "C:\AdventureWorks.BAK" and click "OK"
Click "OK" again to create the backup.
dear friends,
thank you all for the information.
Click File, and then click Save As.
Under File Types, click Save Database As.
Under Advanced, click Back Up Database, and then click Save As.
In the Save As dialog box, in the File name box, review the name for your database backup.
dear friend,
Open the database for which you want to create a backup copy and do the following:
1.Click File, and then click Save As.
2.Under File Types, click Save Database As.
3.Under Advanced, click Back Up Database, and then click Save As.
4.In the Save As dialog box, in the File name box, review the name for your database backup.
5.Select the file type you want the backup database to be saved as from the Save as type list, and then click Save.
Open SQL Server Management Studio Express and connect to the SQL server.
Expand Databases.
Right-click on the database you want to back up, then select Tasks > Back up. ...
On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
Select the Backup Type.