KNOWNHOST WIKI

User Tools

Site Tools


developmental:create-or-restore-mysql-mariadb-backups-ssh-command-line

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
developmental:create-or-restore-mysql-mariadb-backups-ssh-command-line [2019/10/11 07:18]
Karson N.
developmental:create-or-restore-mysql-mariadb-backups-ssh-command-line [2020/05/13 13:22] (current)
Karson N. [Importing a MySQL database]
Line 3: Line 3:
 Importing and dumping backups from command line is more efficient than using a GUI like phpmyadmin. Command line queries for MySQL don't follow any PHP limits, so importing or exporting a MySQL backup is easier and it's very unlikely that you'll run into any errors that phpmyadmin might. Importing and dumping backups from command line is more efficient than using a GUI like phpmyadmin. Command line queries for MySQL don't follow any PHP limits, so importing or exporting a MySQL backup is easier and it's very unlikely that you'll run into any errors that phpmyadmin might.
  
 +\\
 ===== Dumping a MySQL database, explained ===== ===== Dumping a MySQL database, explained =====
 The command "mysqldump" writes a plain text version of your database(s) including the CREATE DATABASE and USE commands, essentially printing a snapshot of your current database. Running just the command will print out the entire database with all the statements, but nothing else - so you'll need to pipe the output to another command or crocodile it into a file. The command "mysqldump" writes a plain text version of your database(s) including the CREATE DATABASE and USE commands, essentially printing a snapshot of your current database. Running just the command will print out the entire database with all the statements, but nothing else - so you'll need to pipe the output to another command or crocodile it into a file.
  
 +\\
 ===== Creating a MySQL backup =====  ===== Creating a MySQL backup ===== 
  
Line 40: Line 42:
 {{:developmental:all_databases.png?nolink&800|}} {{:developmental:all_databases.png?nolink&800|}}
  
 +\\
 ===== Importing a MySQL database ===== ===== Importing a MySQL database =====
  
Line 73: Line 76:
 {{:developmental:sed_nonsense.png?nolink&800|}} {{:developmental:sed_nonsense.png?nolink&800|}}
  
 +\\
 ===== Importing multiple databases at once ===== ===== Importing multiple databases at once =====
  
developmental/create-or-restore-mysql-mariadb-backups-ssh-command-line.1570796323.txt.gz · Last modified: 2019/10/11 07:18 by Karson N.