Hans-Christian Andersen
hans.andersen at phulse.com
Wed Nov 30 14:06:24 CST 2011
Does the clients pc have the command line tool mysqldump (usually comes as standard with mysql)? This is a standard tool for exporting databases to flat text files. And then to import it to another machine, you create an empty database and use the standard mysql command to import (ie. mysql dbname < file.sql ). Best regards, Hans-Christian Andersen On 29 Nov 2011, at 23:56, "Michael Maddison" <michael at ddisolutions.com.au> wrote: > Hi Guys, > > I know this is slightly OT but... > > My client was supposed to install a 3rd party app and set it's database > up as SQL Server. > However events have occurred and now they have a MySQL database they > want me to use! > I've never used MySQL as a datasource but I'll assume it should be ok. I > only have to read, no writes, which is something I suppose. > > I'm downloading 5.5 and the Workbench for testing here. > > I only have access to the clients pc with MySQL installed using > TeamViewer, basically a remote desktop tool for those not on the domain. > When I look at the 3rd party apps options page the database stuff IS NOT > SETUP. > How can I tell if the database is in fact installed? Only the command > line client is installed. I REFUSE to do any installations of tools on > their PC... > > Is there a simple way to backup their database (if it exists) and then > load it here? > They only gave me the password to MySQL. Which does work in the command > line tool, not that I know what to do with it :-/ > > Sorry for the OT. > > Cheers > > Michael M > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >