I need to back up a large Vbulletin (forum) database (750mb) On a windows server, so I can FTP the backup to a new Linux server. The instructions Vbulletin give to back up and restore their databases is as follows.
mysqldump –opt -Q -u dbusername -p databasename > backupname.sql
Can I use sqlyog enterprise to carry out the dump with these options –opt and -Q
(if I knew what those options meant it might help :embarrassed:)
Thanks