Ask a Question My Questions Answer Forum FAQs My Account

Display Forum Question

Search for keyword(s) in Westchester County, NY
Question
   Question    posted to Computer Instructors on 01/14/09 11:00 PM, White Plains, NY 10603
Where or in what environment can I issue the MySQLDump statement to backup a MySQL database. Can I do it via  VBScript In ASP . Also, can I use the MySQL BACKUP DATABASE statement? And if so where do I issue that. I do have the MYSQL Control Center installed on my PC. How can I backup a database from inside the MySQL Control Center?
read more...
Specialist Answer 1 of 2
   Answered By     Westech Solutions, 01/14/09 11:24 PM
Westech Solutions
64 Jackson Rd.
Bedford, NY 10506
914-234-6829
Email Company
View Business Info

I will work under the assumption that when you say "MySQL Control Center", you are talking about the MySQL Administrator GUI. If not, using the MySQL Administrator GUI is your best option and can be downloaded for free at http://dev.mysql.com/downloads/gui-tools/5.0.html. Once logged into the GUI, you want to click on the "Backup" tab on the left hand side. This will bring up some backup options. If you are just migrating the database, then you can perform a one time backup from the first screen. Otherwise, scheduled backups are on the third tab.

WesTech Solutions, the company I run, provides managed I/T services (both onsite and remotely). Feel free to contact us directly if you have any further questions.

Douglas Holdgrafer
Managing Partner
WesTech Solutions, LLC

(914) 595-6335
www.westechsolutions.com

read more...
Specialist Answer 2 of 2
   Answered By     Orange Crystal Consulting, 01/15/09 12:15 AM
Orange Crystal Consulting

Briarcliff Manor, NY 10510
914-469-7545
Email Company
View Business Info
First my contact information then a free tip! Gary E. Goodman, President Orange Crystal Consulting A Premier Briarcliff Computer Services Company http://www.orangecrystalconsulting.com ph: 914-469-7545 email: support@orangecrystalconsulting.com alt email: gary.goodman@orangecrystalconsulting.com Per the Sun manual: there are generally three ways to invoke mysqldump: shell> mysqldump [options] db_name [tables] shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...] shell> mysqldump [options] --all-databases That's your free tip! As far as can you do it in VBScript in ASP? and the rest. I do not have MySQL Control Center running on my lab machines but I can definitely install it and create the platform and answer all the rest of your questions. Call me if you have a budget in mind to compel me to set up the test platform in my lab!
read more...
Login to Reply
The content posted on ZOOMNIA has not been evaluated for accuracy, and ZOOMNIA does not guarantee either its accuracy or
its relevance for any particular situation. Click here for the full Disclaimer.
© ZOOMNIA Corporation