Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

MySQL commands with batch files

Comment:

I was wondering if it was possible to get the current list of tables, within MySQL, and then do a OPTIMIZE TABLE `name`? So I need to store the name in a variable, I figure, then do some sort of loop for each name? Or, if possible, get the batch file to open up a internet explorer page and once it's done loading / after about 20 seconds it can kill the process? Thanks!

Reply:

The mysqlshow command will give you a list of tables. mysqlshow databasename You can script mysql functions by passing the sql part with -e mysql databasename -e "SQL CODE HERE" Have a look at the supplied documentation for additional details.

0

Reply:

mysqlcheck --optimize --all-databases or --databases [db_name} mysqlshow [options] [db_name]

0

running multiple batch

microsoft visual basic 20...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I was wondering if it is possible to get the last line of a text file and save it to a variable? I found a script that gets the first line, but I have been unable to write one of my own. I could...

Summary: @Echo Off For /F "tokens=* delims=" %%J in ('Type "C:\Documents and Settings\admin\My Documents\email test.txt"') Do ( Echo.^<%%J^>>>"C:\Documents and Settings\admin\My Documents\email test1.txt") ...

Summary: I have asimilar question and I am not sure how to modify your answer to fit my needs, could you point me in the right direction. here it is: I have a text file with the following info: lm_loweralph...