xianx · March 3, 2021 21:21 · Mar 27, 2020 · Mar 27, 2020 · Mar 27, 2020 · Nov 1, 2018
diff --git a/Limiting the number of records.md b/Limiting the number of records.md
@@ -2,4 +2,22 @@ Limiting the number of records from mysqldump
 
 mysqldump --opt --where="1 limit 1000000" database
 
-that would give you the first million rows from every table.
+that would give you the first million rows from every table.
+
+---
+
+As the default order is ASC which is rarely what you want in this situation, you need to have a proper database design to make DESC work out of the box. If all your tables have ONE primary key column with the same name (natural or surrogate) you can easily dump the n latest records using:
+
+mysqldump --opt --where="1 ORDER BY id DESC limit 1000000" --all-databases > dump.sql
+This is a perfect reason to why you should always name your PK's id and avoid composite PK's, even in association tables (use surrogate keys instead).
+
+---
+
+f you want to get n records from a specific table you can do something like this:
+
+mysqldump --opt --where="1 limit 1000000" database table > dump.sql
+This will dump the first 1000000 rows from the table named table into the file dump.sql.
+
+---
+
+Source : https://techtun.es/hzhzLZ
diff --git a/Limiting the number of records → Limiting the number of records.md b/Limiting the number of records → Limiting the number of records.md
diff --git a/Limiting the number of records b/Limiting the number of records
@@ -0,0 +1,5 @@
+Limiting the number of records from mysqldump
+
+mysqldump --opt --where="1 limit 1000000" database
+
+that would give you the first million rows from every table.
diff --git a/MySQL Backup Restore.md b/MySQL Backup Restore.md
@@ -30,5 +30,5 @@ mysql -u username -p -v Database_Name < /path/to/mysql_DUMP_File_Name.sql
 **Restoring into another Remote Host database**
 
 ```
-mysql --host=Host_Name --user=User_Name --password=Password --verbose Database_Name > /path/to/mysql_DUMP_File.sql
+mysql --host=Host_Name --user=User_Name --password=Password --verbose Database_Name < /path/to/mysql_DUMP_File.sql
 ```
diff --git a/MySQL Backup Restore.md b/MySQL Backup Restore.md
@@ -25,6 +25,10 @@ mysqldump --user=User_Name --password=Password Database_Name Table_Name > /path/
 ```
 mysql -u username -p -v Database_Name < /path/to/mysql_DUMP_File_Name.sql
 ```
+
+
+**Restoring into another Remote Host database**
+
 ```
-mysql --user=User_Name --password=Password --verbose Database_Name > /path/to/mysql_DUMP_File.sql
+mysql --host=Host_Name --user=User_Name --password=Password --verbose Database_Name > /path/to/mysql_DUMP_File.sql
 ```
diff --git a/MySQL Backup Restore.md b/MySQL Backup Restore.md
@@ -23,8 +23,8 @@ mysqldump --user=User_Name --password=Password Database_Name Table_Name > /path/
 **Restoring the single table into another database**
 
 ```
-mysql -u username -p Database_Name < /path/to/mysql_DUMP_File_Name.sql
+mysql -u username -p -v Database_Name < /path/to/mysql_DUMP_File_Name.sql
 ```
 ```
-mysql --user=User_Name --password=Password Database_Name > /path/to/mysql_DUMP_File.sql
+mysql --user=User_Name --password=Password --verbose Database_Name > /path/to/mysql_DUMP_File.sql
 ```
diff --git a/MySQL Backup of Latest 'X' Records.md → MySQL Backup of Latest X Records.md b/MySQL Backup of Latest 'X' Records.md → MySQL Backup of Latest X Records.md
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -7,4 +7,5 @@ mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
 ** Restore single database with verbose output**
 
 ```
-mysql -u USERNAME -pPASSWORD -v DATABASENAME <  DATABASENAME.sql
+mysql -u USERNAME -pPASSWORD -v DATABASENAME <  DATABASENAME.sql
+```
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -1,10 +1,10 @@
-** Backup a single database with verbose output
+** Backup a single database with verbose output**
 
 ```
 mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
 ```
 
-** Restore single database with verbose output
+** Restore single database with verbose output**
 
 ```
 mysql -u USERNAME -pPASSWORD -v DATABASENAME <  DATABASENAME.sql
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -1,10 +1,10 @@
-*** Backup a single database with verbose output
+** Backup a single database with verbose output
 
 ```
 mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
 ```
 
-*** Restore single database with verbose output
+** Restore single database with verbose output
 
 ```
 mysql -u USERNAME -pPASSWORD -v DATABASENAME <  DATABASENAME.sql
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -1,5 +1,10 @@
-### Backup a single database
+*** Backup a single database with verbose output
 
 ```
 mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
-```
+```
+
+*** Restore single database with verbose output
+
+```
+mysql -u USERNAME -pPASSWORD -v DATABASENAME <  DATABASENAME.sql
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -1,5 +1,5 @@
 ### Backup a single database
 
 ```
-mqsqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
+mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
 ```
diff --git a/Basic MySQL Backup.md b/Basic MySQL Backup.md
@@ -0,0 +1,5 @@
+### Backup a single database
+
+```
+mqsqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql
+```
diff --git a/new_gist_file.md → MySQL Backup with Ignore Table.md b/new_gist_file.md → MySQL Backup with Ignore Table.md
diff --git a/new_gist_file.md b/new_gist_file.md
@@ -0,0 +1,7 @@
+
+```
+mysqldump -u username -p database --ignore-table=database.table1 --ignore-table=database.table2 > database.sql
+```
+```
+mysqldump -u dave -ppassword -h localhost --ignore-table=my_db_name.my_table_name my_db_name
+```
diff --git a/MySQL Backup Restore.md b/MySQL Backup Restore.md
@@ -11,7 +11,7 @@ mysqldump --user=User_Name --password=Password --all-databases > /path/to/mysql_
 ### Single Table Backup and Restore 
 
 
-**Backup a single table from a database**
+**Backingup a single table from a database**
 
 ```
 mysqldump -u username -p Database_Name Table_Name > /path/to/mysql_DUMP_File.sql

diff --git a/MySQL Backup Restore.md b/MySQL Backup Restore.md
@@ -11,7 +11,7 @@ mysqldump --user=User_Name --password=Password --all-databases > /path/to/mysql_
 ### Single Table Backup and Restore 
 
 
-**Backuping a single table from a database**
+**Backup a single table from a database**
 
 ```
 mysqldump -u username -p Database_Name Table_Name > /path/to/mysql_DUMP_File.sql

diff --git a/MySQL Backup Restore → MySQL Backup Restore.md b/MySQL Backup Restore → MySQL Backup Restore.md
@@ -1,36 +1,30 @@
-**************************************************
-*
-* All Database Backup and Restore 
-*
-**************************************************
 
+### All Database Backup and Restore 
 
+**Backingup all database**
 
-#Backingup all database
-
+```
 mysqldump --user=User_Name --password=Password --all-databases > /path/to/mysql_DUMP_File.sql
+```
 
 
-
-**************************************************
-*
-* Single Table Backup and Restore 
-*
-**************************************************
+### Single Table Backup and Restore 
 
 
+**Backuping a single table from a database**
 
-#Backuping a single table from a database
-
+```
 mysqldump -u username -p Database_Name Table_Name > /path/to/mysql_DUMP_File.sql
-
+```
+```
 mysqldump --user=User_Name --password=Password Database_Name Table_Name > /path/to/mysql_DUMP_File.sql
+```
 
+**Restoring the single table into another database**
 
-
-#Restoring the single table into another database
-
+```
 mysql -u username -p Database_Name < /path/to/mysql_DUMP_File_Name.sql
-
+```
+```
 mysql --user=User_Name --password=Password Database_Name > /path/to/mysql_DUMP_File.sql
-
+```
diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-**where %OPTION%**
+__where %OPTION%__
 
 ```
 --where="TRUE ORDER BY id DESC LIMIT 1000"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -1,5 +1,5 @@
 
-## Latest 'X' Records from a Single Table
+### Latest 'X' Records from a Single Table
 
 
 ```
@@ -16,7 +16,7 @@ mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/
 ```
 
 
-## Latest 'X' Records from a All Database
+### Latest 'X' Records from a All Database
 
 ```
 mysqldump -u User_Name -p --where="true limit 1000" --all-databases > /path/to/mysql_DUMP_File.sql

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -1,6 +1,6 @@
 
-Latest 'X' Records from a Single Table
-----
+## Latest 'X' Records from a Single Table
+
 
 ```
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
@@ -16,8 +16,7 @@ mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/
 ```
 
 
-Latest 'X' Records from a All Database
-----
+## Latest 'X' Records from a All Database
 
 ```
 mysqldump -u User_Name -p --where="true limit 1000" --all-databases > /path/to/mysql_DUMP_File.sql

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -9,22 +9,21 @@ mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/
 **where %OPTION%**
 
 ```
+--where="TRUE ORDER BY id DESC LIMIT 1000"
 --where="TRUE LIMIT 500"
 --where="mailbox_id=45"
 --where="mailbox_id=45 AND TRUE ORDER BY id DESC LIMIT 300"
 ```
 
 
-Latest 'X' Records from a Single Table
+Latest 'X' Records from a All Database
 ----
 
-
 ```
 mysqldump -u User_Name -p --where="true limit 1000" --all-databases > /path/to/mysql_DUMP_File.sql
 
 ```
 
 
 
-
 --opt	=> Shorthand for --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset
diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-where %OPTION%
+**where %OPTION%**
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-__ --where %OPTION% __
+where %OPTION%
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-**--where %OPTION%**
+__ --where %OPTION% __
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-*--where %OPTION%*
+**--where %OPTION%**
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-#### --where %OPTION%
+*--where %OPTION%*
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -3,10 +3,10 @@ Latest 'X' Records from a Single Table
 ----
 
 ```
-mysqldump -u username -p --where="(OPTION)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
+mysqldump -u username -p --where="(%OPTION%)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-#### --where
+#### --where %OPTION%
 
 ```
 --where="TRUE LIMIT 500"

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -3,7 +3,7 @@ Latest 'X' Records from a Single Table
 ----
 
 ```
-mysqldump -u username -p --where="true LIMIT 1000" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
+mysqldump -u username -p --where="(OPTION)" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
 #### --where

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,29 +6,17 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="true LIMIT 1000" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-### --where
+#### --where
 
 ```
-mysqldump --where="TRUE LIMIT 500"
-mysqldump --where="mailbox_id=45"
-mysqldump --where="mailbox_id=45 AND TRUE ORDER BY id DESC LIMIT 300"
+--where="TRUE LIMIT 500"
+--where="mailbox_id=45"
+--where="mailbox_id=45 AND TRUE ORDER BY id DESC LIMIT 300"
 ```
-```
-mysqldump -u username -p --where="id<1000" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
-```
-
-```
-mysqldump --user=User_Name --password=Password --opt --where="true LIMIT 1000" > /path/to/mysql_DUMP_File.sql
-```
-
-```
-mysqldump -u username -p --where="TRUE ORDER BY id DESC LIMIT 1000" Database_Name Table_Name > /path/to/mysql_DUMP_File.sql
-```
-
 
 
-
-## Latest 'X' Records from a Single Table
+Latest 'X' Records from a Single Table
+----
 
 
 ```

diff --git a/MySQL Backup of Latest 'X' Records.md b/MySQL Backup of Latest 'X' Records.md
@@ -6,7 +6,7 @@ Latest 'X' Records from a Single Table
 mysqldump -u username -p --where="true LIMIT 1000" Database_Name Table_Name  > /path/to/mysql_DUMP_File.sql
 ```
 
-###
+### --where
 
 ```
 mysqldump --where="TRUE LIMIT 500"
No results found