As a topic, I would like to know whether it is possible to use mysqldump by excluding some databases under Windows. Gogal has happened and I have come to know this:
But I am looking for a solution under windows which does not require external equipment like PowerShell, GNUWIN 32 and so on. Thank you.
This is my last script. This obviously requires the ODBC driver. Set ("ADODB.Connection") set rs = CreateObject ("ADODB.Recordset") set OSHL = WScript.CreateObject ("WScript.Shell") user = "my_user" password = "my_password" mysqlPath = "C: \ Mysql_path \ bin \ mysqldump.exe "bkDate = TravelTree (" yyyy ", date) _ & amp; Right ("0" and dottedpart ("m", date), 2) _ & amp; Right ("0" and dottedpart ("d", dated), 2) Dumppath = "c: \ my_path \ dump_" & amp; BKDet & amp; ".txt" strDbList = "" cn.connectionString = "driver = {MySQL ODBC 5.1 driver}; server = localhost; user =" and user & amp; "; Password =" and password & amp; ";" Select schema_names from "cn.open rs.open" info_schema.schemata where schema_name is not ('db1', 'db2', '.....') in order, schema_name ", cn, 3 rs.MoveFirst while rs.eof not StrDbList = StrDbList & amp; RS (0) & amp; "" R. Movnnet Wend Oeshel. Rain "CMD / K" & amp; MySpace & amp; "-U" & amp; User & amp; "-P" & amp; Password & amp; "- Database" & amp; StrDbList & amp; "& Gt;" & Amp; CRR (34) & amp; Dump & amp; Chr (34), 0 cn.close set oShell = nothing set RS = some
Hope this helps someone else
Comments
Post a Comment