Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Spring Framework | Web Services | BioInformatics | Java Server Faces | Jboss 3.0 tutorial | Hibernate 3.0 | XML

Tutorial Categories: Ajax | Articles | JSP | Bioinformatics | Database | Free Books | Hibernate | J2EE | J2ME | Java | JavaScript | JDBC | JMS | Linux | MS Technology | PHP | RMI | Web-Services | Servlets | Struts | UML


Java Tutorials



Struts Tutorials

Struts Resources

Visit Forum! Post Questions!
Jobs At RoseIndia.net!

Mysql Mysql_backup_restore

User Comments
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl
  Blink   Furl   Simpy   Y! MyWeb 

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 

Current Comments

17 comments so far (post your own) View All Comments Latest 10 Comments:

user name =root

mysql> mysqldump -u root -p dada vote>backdada.sql
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
dump -u root -p dada vote>backdada.sql' at line 1

Posted by dadaso on Tuesday, 03.23.10 @ 19:45pm | #95791

thank you so much......it really helped a lot :)

Posted by Pallavi Nagaraja on Thursday, 02.11.10 @ 14:29pm | #94771

When i use the command , this message comes -'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

Posted by MUSAAZI JOSEPH on Friday, 05.1.09 @ 13:48pm | #87315

Too much steps and info..
use inbuilt commands instead.

Posted by joxxon on Monday, 03.2.09 @ 08:45am | #85391

give the information about basic mysql

Posted by amit on Tuesday, 02.17.09 @ 06:16am | #84931

really it is very very useful.
may god bless u all for ur knoweledge sharing

Posted by srikanth on Tuesday, 01.20.09 @ 00:26am | #83963

This is really a nice tutorial for db backup. But i want to know about the live server db backup. Is there any settings to do that manually or by scripts???

Nishant Ranjan

Posted by Nishant Ranjan on Friday, 01.9.09 @ 00:12am | #83632

We are using Toad tool for MySQl.How to take backup for MYSQL using toad or is there anu other tool.

Posted by Shrikant on Monday, 12.8.08 @ 04:11am | #82501

How do you download this tutorial ?

Posted by kreasen on Saturday, 11.1.08 @ 14:29pm | #81462

please tell me, what is the procedure to retreive of corrupted oracle database in linux server

Posted by rajeev ranjan on Monday, 09.29.08 @ 16:12pm | #80774

Can u please scugesst which is the best tool to backup the mysql data.

Posted by reshma on Wednesday, 03.26.08 @ 13:13pm | #54379

very helpful.

Posted by karimayubar on Wednesday, 03.12.08 @ 07:43am | #52430

I wrote a simple java program that helps automate your nightly backups based upon the mysqldump command. You might find it useful: http://uptecs.com/mysqlbackup/

Posted by Jacob Rhoden on Tuesday, 11.27.07 @ 17:43pm | #40716

mysql database backup
how to backup and restore the MySQL Database

Posted by sivaprasad on Wednesday, 10.31.07 @ 11:50am | #35226

its very helpfull.. thanks ...

Posted by SMITESH on Tuesday, 10.9.07 @ 11:36am | #32605

Hi All,
Its good that the syntax is given for the backup and restore for mysql in different environment.

I would like to do the backup and restore in the same environment (Windows)..
What are the steps that are to be followed..

Posted by vamsi on Saturday, 08.4.07 @ 13:49pm | #22641

keep it up

Posted by vinod kaushik on Wednesday, 06.20.07 @ 19:01pm | #19794

Ask programming questions?



Back to Tutorial


  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Tell A Friend
Your Friend Name


Browse all Java Tutorials
Java JSP Struts Servlets Hibernate XML
Ajax JDBC EJB MySQL JavaScript JSF
Maven2 Tutorial JEE5 Tutorial Java Threading Tutorial Photoshop Tutorials Linux Technology
Technology Revolutions Eclipse Spring Tutorial Bioinformatics Tutorials Tools SQL

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright 2007. All rights reserved.