Home Discussion Discuss: Backing Up and Restoring A MySQL Database

  • unable to do soAbhishek Dixit October 8, 2011 at 2:46 PM

    I tried the commands you mentioned as follows mysqldump -u root -p accounts > accounts.sql Enter password: mysqldump: Got error: 1049: Unknown database 'accounts' when selecting the database

  • Using a third party toolAlejandro Arauz October 10, 2011 at 10:46 PM

    If what you want is to backup your database in an easy way without running scripts I would recommend MySqlBackupFTP (http://mysqlbackupftp.com/). It has a fully functional free version that allows you to schedule backups.

  • Thank youFatima December 23, 2011 at 6:01 PM

    Thank you for the article

  • Java Mysql ProblemDevendra Yadav January 18, 2012 at 10:35 PM

    I want to take the backup of my all the table with data. It happened but it does not carrying the table and it's data. I m making the project in java with mysql plz email me the solution to keep backup with table and it's tables

  • Good JobRajus February 20, 2012 at 8:23 PM

    Its a very nice article.

  • Schema_level_backupHow to take schema level backup in mySQL database at OS level. And also how to find the size of a schema in MySQL database. April 30, 2012 at 2:00 PM

    Please help me. Thanks in advance. Regards, Thirumalai

  • thanksfaisal June 27, 2012 at 5:36 PM

    thanking you from faisal wincom pvt ltd.

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
MySQL

Backing Up and Restoring A MySQL Database
; backup data can be used to restore the Database. Backing Up MySQL Database MySQL... of backing up MySQL Database named "accounts" into text file... admin -p admin --no-create-info accounts > accounts.sql Restoring MySQL Database 

MySQL

Backing Up and Restoring A MySQL Database
; backup data can be used to restore the Database. Backing Up MySQL Database... the example of backing up MySQL Database named "accounts" into text file... Database Restoring the MySQL is very easy job. You can use the following 

MySQL

Setting up MySQL Database and Tables
Setting up MySQL Database and Tables   ... Database and you know how to work with the MySQL database. To access the database... and descriptions. Here is the complete sql script for setting up the database 

Struts Examples

Setting up MySQL Database and Tables
 

PHP Tutorial

Setting up the database in PHP
PHP DATABASE Setup Part-5(a) : Setting up the database In this chapter, we will tell you how to create a database and tables in MySQL and also how... is the procedure to construct database. Database Construction The best thing about MySQL 

PHP Tutorial

Setting up Database with the help of PHP Scripts.
in the last tutorial that MySQL has its own standard set up to create database which...PHP Database Set Up Script Part-5(c) : Setting up the database 2. Database...;CREATE DATABASE ".$database; $conn = mysql_connect($hostname 

JSP Servlet Questions

Backup MySQL Database - JSP-Servlet
Backup MySQL Database  Database Sir I have been reading Rose's india tutorial "Using MySQL Database with JSP/Servlet". In the Tutorial you have shown an example of backing up the database. When I tried to backup database 

HTML Questions

how to fill up a form automaically from database and print it
how to fill up a form automaically from database and print it  sir,i...)should automatically fill up in the form and on cliking print button it shoulg give..."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost 

General

Navigate database values using up and down key of keyboard
Navigate database values using up and down key of keyboard In this section, you will learn how to navigate database values using up and down keys... the database values. On pressing the up key, the following code will fetch one by one 

General

Welcome to the MySQL Tutorials
hands an experience with MYSQL database   Backing Up and Restoring A MySQL Database In this lession you will learn how to take MySQL...;    The MySQL database server is most popular database 

MySQL

MySQL Creating and Deleting Database
MySQL Creating and Deleting Database   ... and delete the database in MySQL. MySQL provides the both commands. In this section you... privilege for the mysql database. MySQL drop User syntax: The DROP USER statement 

PHP Tutorial

Adding pop up menu on headlines.
($database,$link) or exit ("Database Selection Error:" .mysql_error...Adding pop up menu on Headlines Here you will learn sticking a pop up menu... on to pop up menu, it opens the list of the menu automatically. For generating 

MySQL

MySQL default port number and how to change it
Create Database Backing Up and Restoring A MySQL Database...What is default port number of MySQL Database server? This tutorial.... This information is very important for you if you are working with MySQL Database server 

JavaScript Questions

Dependant & dynamic drop down list - Follow up
").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql...(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test...){ System.out.println(e); } %> For the above code, we have created two database tables 

Java Beginners

How to connect to the database to my application if my database is made up in oracle
How to connect to the database to my application if my database is made up in oracle   How to connect to the database to my application if my database is made up in oracle 

JSP Servlet Questions

how to check the radio button automatically depending up on the value of database when editing the form...
how to check the radio button automatically depending up on the value of database when editing the form...  hi...in my application i am editing the form and in that form the data in the database should come but icant be able 

SQL Question

update mysql database
update mysql database  update mysql database 

Swing AWT

binding jComboBox to mysql database - Swing AWT
binding jComboBox to mysql database  I am using netbeans 6.5 How to populate jComboBox with data of specific column of mysql database table? I... = null; String url = "jdbc:mysql://localhost:3306/"; String db 

General

MySQL default port number in Linux
JDBC Example with MySQL MySQL Create Database Backing Up and Restoring A MySQL Database Repairing mysql database from... of MySQL in Linux? If you are using MySQL database server installed on the Linux 

JDBC Questions

Query to insert values in the empty fields in the last row of a table in Mysql database?
Query to insert values in the empty fields in the last row of a table in Mysql database?  I have some fields filled and some fields empty in the last row of my MYSQL database. Now I want to fill up those empty fields in the last 

Date Calendar

mysql
mysql  what is database 

SQL Question

Database - mysql - SQL
Database - mysql size limit  What is the size limit for any mysql database 

SQL Question

mysql
you need to download the mysql-connector jar file for connecting java program from mysql database.......   Hi friend, MySQL is open source database... is the link for the page from where you can understand how to Download and Install MySQL 

JDBC Questions

insert images into a Mysql database
insert images into a Mysql database  How can I insert images into a Mysql database 

Java Beginners

How to connect to database to my application if the database is made up in oracle
How to connect to database to my application if the database is made up in oracle  How to connect to database to my application if the database is made up in oracle   Hi Friend, Follow these steps: 1) Import 

MySQL

MySQL Front
Database. These MySQL Front tools actually helps you in working fast and easily with the MySQL database. Here is the list of MySQL Front end tools: What...-developers using the popular MySQL-Database. It allows you to manage and browse 

XML Questions

XML parsing to Mysql database
XML parsing to Mysql database  Can someone please post the code for parsing an XML file into Mysql database using SAX 

MySQL

MySQL Database
the code is up to.     MySQL database connected... MySQL Database       MYSQL...; The Database Design for MySQL Database Designer for MySQL is a handy tool 

PHP Questions

mysql query
mysql query  how do transfer into the excel data to my sql  ...("sun.jdbc.odbc.JdbcOdbcDriver") in your php code and set up the connection... the mysql connection in your php and store the list values inside the mysql 

JDBC Questions

Connecting to MYSQL Database in Java
Connecting to MYSQL Database in Java  I've tried executing the code...("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost/"; String dbName = "textbook"; String driver 

DMCA.com