0%
How can I export a database SQL dump to be ready for Artifakt ?
Search

Prepare your database SQL dump

If you don't use a third party tool to manage your database, such as Sequel Pro or MySQL Workbench, you can export your database SQL dump by connecting to your current SSH environment and using the following command:


mysqldump --single-transaction -h <hostname> -u <username> <database name> --triggers | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > you_db.`date +"%Y%m%d"`.sql.gz
0%
0%