aquila Posted January 31, 2009 Posted January 31, 2009 Hello guys, On my PC there are three files called *.MYD, *.MYI and *.FRM. Okay. With phpmyadmin I can make a dump -> *.sql. Is that possible with autoit? Cause the .sql file I can read out. The MySQL UDFs always crash, so i want to do it with that way. I have to say I have no knowledge about MySQL so if someone knows another way how I can read out the File, please tell me . aquila
ProgAndy Posted January 31, 2009 Posted January 31, 2009 Did you try these http://www.autoitscript.com/forum/index.ph...p;hl=MySQL+UDFsand these? http://www.autoitscript.com/forum/index.ph...p;hl=MySQL+UDFs *GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes
aquila Posted January 31, 2009 Author Posted January 31, 2009 Hello! Yes, I tried it again now, but same Problems. With the first link I get "unkown database" with all 3 files. Which file is actually the necessary one? The second link i get: $Objconn.open ("DRIVER=" & $sDriver & ";SERVER=" & $sServer & ";DATABASE=" & $sDatabase & ";UID=" & $sUsername & ";PWD=" & $sPassword & ";PORT="&$iPort) $Objconn.open ("DRIVER=" & $sDriver & ";SERVER=" & $sServer & ";DATABASE=" & $sDatabase & ";UID=" & $sUsername & ";PWD=" & $sPassword & ";PORT="&$iPort)^ ERROR This sucks Isn't it possible to get a .sql dumb?
ProgAndy Posted January 31, 2009 Posted January 31, 2009 (edited) Why don't you try this UDF first? http://www.autoitscript.com/forum/index.ph...p;hl=MySQL+UDFs It uses an othr method to connect to the DBTo get an SQL dump, you could use the mysql.exe which comes with an MySQL-Installation.//Edit: You mustn't open these files directly. You have to use the database server like phpmyadmin. Edited January 31, 2009 by ProgAndy *GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes
aquila Posted January 31, 2009 Author Posted January 31, 2009 Hey Progandy, If I use the database server it crashs. How can i use the mysql.exe for a dump? cannot find any topics about that. This would be the best.
ProgAndy Posted January 31, 2009 Posted January 31, 2009 (edited) http://www.griessmeier.de/linux/mysql_backup.htm#1//Edit: Soory, i meant mysqldump Edited January 31, 2009 by ProgAndy *GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now