1. My Freespirits
  3. Freespirits Forum
  5. Main Forum
  7. English Section
  9. Mysql
  11. How to import or export MySQL database with command line.
× English Section!

We will be more than happy to help you with problems related to our services and products. Please feel free to write it down as clear as possible

How to import or export MySQL database with command line.

Περισσότερα
5 Χρόνια 11 Μήνες πριν - 2 Χρόνια 2 Μήνες πριν #70 από infogate
How to import or export MySQL database with command line. δημιουργήθηκε από infogate
This is also useful when working with big databases.

Export database info file
mysqldump DATABASE-NAME > FILE-NAME.sql
Export database into compressed file to save space
mysqldump DATABASE-NAME | gzip > FILE-NAME.sql.gz
Export database into compressed file with date name to save space
mysqldump DATABASE-NAME | gzip > "FILE-NAME_`date +%e_%b_%Y`.sql.gz"
Import database
mysql DATABASE-NAME < FILE-NAME.sql
mysql mojtest_test1 < mojtest_test1.sql

Import compressed database .gz file
gunzip FILE-NAME.sql.gz
mysql DATABASE-NAME < FILE-NAME.sql
mysql mojtest_test1 < mojtest_test1.sql

*If you want to export file in a particular folder you should first get in the folder and then run the export command using cd folder.

If you want to get the file from one server to another server then you should put the file to a public folder to the source server and just run the following command from the destination server.
wget https://domain.com/backup.tar.gz

The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Last edit: 2 Χρόνια 2 Μήνες πριν by infogate.

Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.

  1. My Freespirits
  3. Freespirits Forum
  5. Main Forum
  7. English Section
  9. Mysql
  11. How to import or export MySQL database with command line.
Χρόνος δημιουργίας σελίδας: 0.033 δευτερόλεπτα
Powered by Kunena Φόρουμ