[DiscordArchive] What are you trying to do? make a complete backup?
[DiscordArchive] What are you trying to do? make a complete backup?
Original source
What are you trying to do? make a complete backup?
rektbyfaith
12-19-2023, 05:20 PM #1Archived author: Abillister • Posted: 2023-12-19T17:20:21.324000+00:00
Original source
What are you trying to do? make a complete backup?
Original source
yes
rektbyfaith
12-19-2023, 05:20 PM #2Archived author: ✵♰✵ • Posted: 2023-12-19T17:20:30.108000+00:00
Original source
yes
Original source
Theoretically you want to change that drop down to include the data then. I have not used Heidi but I'm assuming that is scripting out the database. The goal being that you can either output just the STRUCTURE (ie: development environment where you need the structure and not data) or export the structure WITH data.
rektbyfaith
12-19-2023, 05:21 PM #3Archived author: Abillister • Posted: 2023-12-19T17:21:49.420000+00:00
Original source
Theoretically you want to change that drop down to include the data then. I have not used Heidi but I'm assuming that is scripting out the database. The goal being that you can either output just the STRUCTURE (ie: development environment where you need the structure and not data) or export the structure WITH data.
Original source
You can also use MySQL CLI commands to do it, give me a moment and I can share an example:
rektbyfaith
12-19-2023, 05:22 PM #4Archived author: Abillister • Posted: 2023-12-19T17:22:02.040000+00:00
Original source
You can also use MySQL CLI commands to do it, give me a moment and I can share an example:
Original source
thanks if you have any guide
rektbyfaith
12-19-2023, 05:22 PM #5Archived author: ✵♰✵ • Posted: 2023-12-19T17:22:18.008000+00:00
Original source
thanks if you have any guide
Original source
will help me
rektbyfaith
12-19-2023, 05:22 PM #6Archived author: ✵♰✵ • Posted: 2023-12-19T17:22:26.115000+00:00
Original source
will help me
Original source
Below is a quick/ugly example. Theoretically you can do a single line pipe statement for the zip - but I was having issues so just did an ugly hack. You also "should not" use a plain text password method...
`set FileName=WoW_Backup_Example_%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
mysqldump -u <admin_DB_user> -p<plaintext_password> --single-transaction --flush-logs --all-databases > "c:\example\%filename%.sql"
tar.exe -a -cf "c:\example2\%FileName%.zip" "c:\example\%filename%.sql"
DEL "c:\example\%filename%.sql"`
rektbyfaith
12-19-2023, 05:25 PM #7Archived author: Abillister • Posted: 2023-12-19T17:25:03.539000+00:00
Original source
Below is a quick/ugly example. Theoretically you can do a single line pipe statement for the zip - but I was having issues so just did an ugly hack. You also "should not" use a plain text password method...
`set FileName=WoW_Backup_Example_%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
mysqldump -u <admin_DB_user> -p<plaintext_password> --single-transaction --flush-logs --all-databases > "c:\example\%filename%.sql"
tar.exe -a -cf "c:\example2\%FileName%.zip" "c:\example\%filename%.sql"
DEL "c:\example\%filename%.sql"`
Original source
https://www.sqlshack.com/how-to-backup-a...p-command/
[Embed: How to backup and restore MySQL databases using the mysqldump command]
In this article, I have explained how we can use mysqldump utility to backup and restore the MySQL database.
https://www.sqlshack.com/how-to-backup-a...p-command/
rektbyfaith
12-19-2023, 05:25 PM #8Archived author: Abillister • Posted: 2023-12-19T17:25:44.042000+00:00
Original source
https://www.sqlshack.com/how-to-backup-a...p-command/
[Embed: How to backup and restore MySQL databases using the mysqldump command]
In this article, I have explained how we can use mysqldump utility to backup and restore the MySQL database.
https://www.sqlshack.com/how-to-backup-a...p-command/
Original source
thank you
rektbyfaith
12-19-2023, 05:26 PM #9Archived author: ✵♰✵ • Posted: 2023-12-19T17:26:36.425000+00:00
Original source
thank you
Original source
(as a note if you are including the plaintext password, there is no space between the -p and the password. So if your password is "password" then it would be "-ppassword")
rektbyfaith
12-19-2023, 05:26 PM #10Archived author: Abillister • Posted: 2023-12-19T17:26:46.785000+00:00
Original source
(as a note if you are including the plaintext password, there is no space between the -p and the password. So if your password is "password" then it would be "-ppassword")
1 Guest(s)
1 Guest(s)