+ Post New Thread
Results 1 to 5 of 5

Thread: How to Back Up and Restore a MySQL Database?

  1. #1
    Junior Member MelissaCaddy1's Avatar
    Join Date
    Aug 2015
    Location
    India
    Posts
    8
    Post Thanks / Like

    How to Back Up and Restore a MySQL Database?



    Please share the commands for creating and restoring database backups.
    Dedicated Server Hosting Support Team

  2. #2
    Administrator Fli's Avatar
    Join Date
    Mar 2013
    Posts
    2,429
    Post Thanks / Like
    Blog Entries
    1


    Is this useful / helpfull? Yes | No
    If You are having Linux server, you can do it from within command line: http://internetlifeforum.com/mysql-apache-php/471-how-backup-restore-mysql-dump-file-linux-command-line/
    Else backup can be usually made from within your hosting control panel..

  3. #3
    Junior Member
    Join Date
    Mar 2017
    Posts
    11
    Post Thanks / Like


    Is this useful / helpfull? Yes | No
    Please try the below steps ...
    Open phpMyAdmin.
    Select your database by clicking the database name in the list on the left of the screen.
    Click the Export link. ...
    In the Export area, click the Select All link to choose all of the tables in your database.

  4. #4
    Junior Member tivanov's Avatar
    Join Date
    Aug 2017
    Posts
    3
    Post Thanks / Like


    Is this useful / helpfull? Yes | No
    Create dump:
    Code:
    mysqldump db_name table_name > db.table.sql
    Restore dump:
    Code:
    mysql db_name < db_name.sql

  5. #5
    Administrator Fli's Avatar
    Join Date
    Mar 2013
    Posts
    2,429
    Post Thanks / Like
    Blog Entries
    1


    Is this useful / helpfull? Yes | No
    Quote Originally Posted by tivanov View Post
    Code:
    mysqldump db_name table_name > db.table.sql
    To dump whole database instead of just one table, try:
    Code:
    mysqldump -u databaseusername -p databasename > db.sql

+ Post New Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
 Protected by : ZB BLOCK  &  StopForumSpam