Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Registered User
    Join Date
    Feb 2014
    Posts
    467

    How to create a backup of Database??

    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.

  2. #2
    Senior Member
    Join Date
    Apr 2014
    Posts
    113
    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.

  3. #3
    Registered User
    Join Date
    Oct 2013
    Posts
    178
    What database type you are using - MySQL, MSSQL, PostgreSQL, another ... ? What hosting plan do you have ?

  4. #4
    Registered User
    Join Date
    Jul 2013
    Posts
    51
    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

  5. #5
    Senior Member
    Join Date
    Apr 2014
    Posts
    107
    If you use ftp to changes in website, copy data before changes.
    Backup data is only to save previous data.

  6. #6
    Registered User
    Join Date
    Jun 2014
    Posts
    2
    Are you using mysql or some other db?

  7. #7
    Registered User
    Join Date
    Mar 2014
    Posts
    10
    Can't really help you without knowing the specific kind of database you're using.

  8. #8
    Senior Member
    Join Date
    May 2013
    Posts
    199
    To backup the database in mysql use the following syntax
    $ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

  9. #9
    Senior Member
    Join Date
    Nov 2013
    Posts
    351
    Have you tried drop box? Dropbox can be a good choice, that can help you back up your files and others.

  10. #10
    Senior Member
    Join Date
    Aug 2018
    Posts
    109
    Try WPvivid backup plugin. It allows you to create backups for database and site files as well as entire website.

  11. #11
    Senior Member
    Join Date
    Jul 2017
    Location
    Bangalore
    Posts
    226
    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.

  12. #12
    Member
    Join Date
    Apr 2019
    Posts
    37
    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.

  13. #13
    Registered User
    Join Date
    Dec 2017
    Posts
    25
    There are some tools, that you can use which can create backup so that you will not gonna face anykind of problems and you will not gonna loose your important data and crucial information.

  14. #14

  15. #15
    Senior Member
    Join Date
    Apr 2019
    Location
    Asia
    Posts
    135
    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.
    ServersBase.Com- sales@serversbase.com
    █ SSD cPanel Web Hosting LiteSpeed MariaDB CloudLinux & MultiPHP!
    Solutions Tailored To Your Requirements For Unbeatable Agility.
    █ Fully Managed Cloud Instances, Daily Backups & Active Monitoring!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.