Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
ALTER DATABASE included in SQL file Options · View
pemtium
#1 Posted : Friday, November 11, 2016 11:45:59 AM
Rank: Newbie

Groups: Registered

Joined: 2/17/2014
Posts: 9
Location: RD
This Sentence are added to the .SQL file

anyway to avoid database name included in backup?
(this make imposible to restore later with other name.)

ALTER DATABASE `DATBASENAME_HERE` CHARACTER SET latin1 COLLATE latin1_general_ci ;
ALTER DATABASE `DATBASENAME_HERE` CHARACTER SET utf8 COLLATE utf8_general_ci ;


ALSO is Adding USE DATABASE


Thank in Advanced
pemtium
#2 Posted : Saturday, November 12, 2016 3:01:57 PM
Rank: Newbie

Groups: Registered

Joined: 2/17/2014
Posts: 9
Location: RD
Maybe beacuase you are adding this parameter as default --databases <databases>
Alexander Omelchenko
#3 Posted : Monday, November 14, 2016 8:13:58 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Hello,

Please note, you can find more information if you run Nlog.file. To enable Nlog, save the attached nlog.config file into the application's folder C:\Program Files (x86)\Pranas.NET\MySQLBackupFTP, restart MySQLBackupFTP application. Then you can run the backup job again and open C:\Log\MySBF\SBF.log file with notepad.
File Attachment(s):
NLog.rar (1kb) downloaded 1 time(s).
pemtium
#4 Posted : Tuesday, November 15, 2016 5:23:00 AM
Rank: Newbie

Groups: Registered

Joined: 2/17/2014
Posts: 9
Location: RD
Thank you alexander, we will test and let you know
pemtium
#5 Posted : Tuesday, December 6, 2016 5:52:31 PM
Rank: Newbie

Groups: Registered

Joined: 2/17/2014
Posts: 9
Location: RD
False Alarm

i will keep Checking
Alexander Omelchenko
#6 Posted : Wednesday, December 7, 2016 1:54:32 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Ok. Please feel free to contact us on any issues or concerns.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com