Batch file mysqldump

Where have you been before? By "not be wrapped" newtover means that all the lines have to be in one line, otherwise you will get syntax error. JubinPatel just use this script in one line without new lines — XandrGuard. I'm in love with you. Show 2 more comments. This is an interesting one. Good one! I will post my answer and will accept yours.

Thanks a lot. Vag Mor Vag Mor 21 2 2 bronze badges. I have the first part of this done, but I'm still working on the backing up of the DB's. I'll update this when I get it. It does not matter which version of MySQL you use. If I'm running a batch file - oh yes, I'm on the local machine. Radio - You voted me down for asking if you were using a different version of SQL? Your commands dont work on my version of SQL You are not reading my question. It's related only to MySQL.

Just read please. I think if you can walk me through unlocking them the script should hopefully work. Then I tried using the root user account and it did dump the file I just created a brand new db from a dump that I had made a while ago.

Thedump I imported happend to be Now, when I ran this batch file the dump it made is only Can there be that much fluctuation in a dump? If I zip up the original dump it compresses to 6. Locking tables is a normal part of the work done by mysqldump. The locking is enabled by the "--lock-tables" option, which is implicit when using the "--opt" option, which is the default. How's that for convoluted? Apparently, the user you're using to do the mysqldump lacks this privilege, if you're seeing an Access Denied error.

The root user is has all privileges, so it won't get the Access Denied error. Yes, it is possible for the output of two mysqldumps of the same database to vary greatly in size, depending on the options used when running the commands e. Compare these to similar queries on your original table.

If the results are different, you know something is wrong. If the results are the same, you know at least that the same number of records were backed up and restored but not necessarily that the content is intact.

Everything seems to hummin a long just fine now. For more information about actions, see Actions. Optional On the Conditions tab of the Create Task dialog box, supply conditions for the task. For more information about the conditions, see Task Conditions. Optional On the Settings tab of the Create Task dialog box, change the settings for the task. For more information about the settings, see Task Settings.

Click the OK button on the Create Task dialog box. Optional : Test your batch file on a dummy directory. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 2.