Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: my-sql(5)
Thread ID: 373365 Message ID: 373405 # Views: 56 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 2:09:59 AM         
   


> Hello experts
>
> i am using mysql 5.5
>
> my question is how take backup of database and it's table
>
> because i want to move to this database into Clint place (another computer)
>
> thanks in advance
I'm using the commdlg32.ocx library..


	#Define SW_NORMAL 1

	xDefault = Set('Default')+Curdir()

	With This
	
		.oleCommDlog.showSave()
		.tbx_export.Value = .oleCommDlog.FileName()
		lcDatabase = 'stcdcfi'
		lcUser = 'root'
		lcHost = 'localhost'
		lcPassword = 'your_password'
		lcPathfile = Trim(.oleCommDlog.FileName())

		If Empty(.tbx_export.Value)
			Messagebox('Backuping Cancelled!',64,'')
			Return
		Else
			Msg = Messagebox('Database Backup in progress....',64,'')
			lcMySQLdump = Fullpath('C:\xampp\mysql\bin\mysqldump.exe')
			lcMySQLdump = Textmerge('cmd /C <<lcMySQLdump>>')
			lcCommand = Textmerge('<<lcMySQLdump>>  -B -q -f -t --insert-ignore --compact <<lcDatabase>> -u<<lcUser>> -p<<lcPassword>> -h<<lcHost>> > <<Msg>> > <<lcPathfile>>')

			oWSShell = Createobject('WScript.Shell')
			oWSShell.Run(lcCommand,0,.T.)
			Messagebox('Database have been backup successfully!',64,'')

		Endif

	Endwith

	Set Default To (m.xDefault)



If you want to understand the codes (-B -q -f -t --insert-ignore --compact) try to read MySQLdump and MySQLimport for importing the database..

Regards:
carbcoder_02

ENTIRE THREAD

my-sql(5) Posted by prasanna kunder @ 3/21/2013 5:30:13 PM
RE: my-sql(5) Posted by llyrad atsituab @ 3/22/2013 2:09:59 AM
RE: my-sql(5) Posted by prasanna kunder @ 3/27/2013 10:07:35 PM