MySQL Forums
Forum List  »  Backup

Help With Backups
Posted by: Anthony Chorley
Date: June 25, 2021 03:57AM

Hello Forum

I am new to MySQL so please have some patience...

I have been tasked with refreshing a particular UAT Schema, however when I've restored the Schema not all of the tables are present.

Details are as follows; -
The size of the schema is 75Gb
The six largest tables contain 2.3Gb, 3.3Gb, 4.8Gb, 13.6Gb, 15.2Gb and 33.8Gb of data.
The method for the backup is a Windows Server scheduled task running a .bat file, the command for the backup is: -
REM BH 26/05/19
@echo on
net use z: /delete /y
Net use z: "\\THE NETWORK SHARE NAME"

set mydate=%date:/=%
set mytime=%time::=%
set mytimestamp=%mydate: =_%_%mytime:.=_%

set dbname=livefive

set filename="E:\Backup\%dbname%-%mytimestamp%.sql"
set filename2="E:\Backup\%dbname%-%mytimestamp%.tz"
echo %filename%
cd "E:\Backup"
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" %dbname% --user=??? --password=??? --host=localhost --port=3306 --quick --lock-tables=false --result-file=%filename% --default-character-set=utf8 --single-transaction=TRUE

I am using MySQL Workbench to perform the restore, the restore completes but there are over a 150 tables missing.

Many Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Help With Backups
485
June 25, 2021 03:57AM
177
June 25, 2021 12:54PM
148
June 28, 2021 02:07AM
151
June 28, 2021 05:01AM
153
June 28, 2021 01:05PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.