Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 To: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 Tags
Subject: RE: my-sql(5)
Thread ID: 373365 Message ID: 373857 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 10:07:35 PM         
   


> > 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


if i copy folder from
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data

and past on another system (ie another server)

it's create any problem

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