Magento Expert Forum - Improve your Magento experience

Results 1 to 6 of 6

Import & Export database in MySQL with mysqldump

  1. #1
    Administrator david's Avatar
    Join Date
    Nov 2012
    Posts
    261
    Thanks
    22
    Thanked 42 Times in 34 Posts

    Post Import & Export database in MySQL with mysqldump

    With magento, we usually meet a big database size what can't import/export via phpmyadmin. For the safe and professional way to do import/export database let 's do it in command line.


    Export A MySQL Database

    This example shows you how to export a database. It is a good idea to export your data often as a backup.

    Using SSH, execute the following command:

    Code:
    mysqldump -p -u username database_name > dbname.sql
    You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name.
    The file dbname.sql now holds a backup of your database and is ready for download to your computer.

    Import A MySQL Database

    The file must be in .sql format. It can not be compressed in a .zip or .tar.gz file.

    Start by uploading the .sql file onto the server

    If you haven't already done so, create the MySQL database via the cpanel.

    Using SSH, navigate to the directory where your .sql file is.

    Next run this command:

    Code:
     mysql -p -u username database_name < file.sql
    Note: The -p will prompt for your account's password.

    Note: username is the user with rights to the database. If you are unsure what the username is you can use the same username and password used to sign into SSH.

    View more threads in the same category:


  2. #2
    Moderator speed2x's Avatar
    Join Date
    Mar 2013
    Location
    Hollywood, Florida, United States
    Posts
    88
    Thanks
    8
    Thanked 7 Times in 6 Posts

    Default

    In almost case, magento database is too big because of log. So that let 's delete all of log before backup. You can see more detail about this in article Optimize magento database by Cleaning log

  3. #3
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    635
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Fare. To Export a database, open up terminal, ensuring that you are not signed into MySQL and type, mysqldump - u [username] - p [database name] > [database name].sql.

    Import.

    Stage One—Shut Down MySQL.

    Stage Two—Access MySQL Safe Mode.

    Stage Three—Set Up a New Password.

  4. #4
    New member
    Join Date
    Feb 2019
    Location
    New york
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Import A MySQL Database

    Stage One—Shut Down MySQL.

    Stage Two—Access MySQL Safe Mode.

    Stage Three—Set Up a New Password.

    You can see more detail about this in article

  5. #5
    Junior Member
    Join Date
    Sep 2018
    Location
    Oman, Muscat
    Posts
    2,084
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    The most effective method to Import and Export Databases. Fare. To Export an information base, open up terminal, ensuring that you are not signed into MySQL and type,

Tags for this Thread

Bookmarks

Posting Permissions

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