Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
public:mysql [2022/07/19 23:26] – [database(s) backup] typos Nico | public:mysql [2022/07/19 23:32] – [database(s) backup] typo Nico | ||
---|---|---|---|
Line 89: | Line 89: | ||
* Here is a backup script you can use (remember to use it on the " | * Here is a backup script you can use (remember to use it on the " | ||
- | < | + | < |
#!/bin/sh | #!/bin/sh | ||
Line 103: | Line 103: | ||
for i in `echo 'show databases;' | for i in `echo 'show databases;' | ||
do | do | ||
- | echo -n " ---> | + | echo -n " ---> |
mysqldump --add-drop-table --add-locks --create-options --disable-keys --extended-insert --single-transaction\ | mysqldump --add-drop-table --add-locks --create-options --disable-keys --extended-insert --single-transaction\ | ||
--databases --lock-tables --quick --set-charset $i > ${BACKUPDIR}/ | --databases --lock-tables --quick --set-charset $i > ${BACKUPDIR}/ |