Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL MySQL take backup of a table - example code needed
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Java Coder
MySQL take backup of a table - example code needed
1 Answer(s)      a year and 10 months ago
Posted in : SQL


How to take backup of a table in MySQL? I have a database which contains many tables. What is the command to take the backup of one table with data from database?

Thanks


Advertisement
View Answers

January 24, 2013 at 7:42 PM


Hello,

mysqldump tool is very useful. You have to use the mysqldump tool to take the backup of one table from database.

The mysqldump tools comes with mysql distribution. You can find it in the bin directory of your MySQL installation.

On Linux it is accessible from the command prompt. You can use the following command to take the backup of one table from database.

mysqldump -u -p mydatabase mytable> mytable.sql

Thanks



Related Tutorials/Questions & Answers:
how to take backup of phone to pc using java code
how to take backup of phone to pc using java code  i want to take the backup of phone data in my pc and also provide the restore functionality,and i want to do it using java program,so can anyone help me
how to take a backup of a table in sql
how to take a backup of a table in sql  how to take a backup of a table in sql?   SQL BackUp Table example
Advertisements
how to take input table name in jsp to create table in mysql?
how to take input table name in jsp to create table in mysql?  how to take input table name in jsp to create table in mysql?   Hello Friend, Try the following code: <%@page import="java.sql.*"%> <form method
java program to take backup for the folders
java program to take backup for the folders  java program to take backup for the folders   Have a look at the following link: Java Copy one folder to another
how to take iphone backup using itunes
how to take iphone backup using itunes  Hi, Can anyone please tell me how to take iphone backup using itunes..?   You can find the details...: Sync with iTunes (disabled if you have iCloud backup turned on) Right-click
I Want to take mqsyl batabase backup using jsp
I Want to take mqsyl batabase backup using jsp   I was develop web portal using jsp and servelt. I need to take backup my MySQL database and restore another one MySQL database.   import java.util.*; import java.io.
PHP mysql database backup script - PHP
PHP mysql database backup script  How can i get the database backup using PHP mysql database
Code Help Needed
Code Help Needed  I am trying to help a buddy of mine with this program and I can't seem to figure it out. I am still working on it but any help would be appreciated. The program is suppose to write to and read from a file
backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5
backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5  backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5
java program to take the backup of folders and copy the folder in different location without deleting the existing one
java program to take the backup of folders and copy the folder in different location without deleting the existing one  java program to take the backup of folders and copy the folder in different location without deleting
Mysql DB backup size increases rapidly
Mysql DB backup size increases rapidly  we are using mysql 5.1 with jboss application server. recently database size increases rapidly. it goes upto 8GB. how can we optimize the DB? or shall we delete any log files? let me know
take data from one table and insert same in another
take data from one table and insert same in another  I want to know when a new field update in table and the same data has to update in another table
urjent code needed - Java Interview Questions
urjent code needed  Coding: - We have Document domain/entity.... Please write a java code that will: 1. Implements hashCode() and equals...){ // your code is here } Document findDocument(Document doc
Getting mysql table in textbox
Getting mysql table in textbox  how to get mysql table values into textbox in java using ajax and servlets
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database... not put table password. neither user and programmer can not delete table nor take
SQL Backup Table
. Understand with Example The Tutorial illustrate a example from SQL Backup Table. In this Example, we create a table 'Stu_Table'. The create table statement... SQL Backup Table      
repair a MySQL table.
repair a MySQL table.  How can we repair a MySQL table?   Hi friends, The syntex for repairing a mysql table is: REPAIR TABLE tablename... will repair the table specified. If QUICK is given, MySQL will do a repair of only
How alter table in MySQL?
How alter table in MySQL?  Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks   ... examples of alter table statements in MySQL. Thanks
mysql table extract
mysql table extract  Hello friends!! I am a trainee. I am learning connectivity of java with MYSQL. I want to extract table from mysql so that I can access it on another computer. I want to attach mysql table to my java NETBEANS
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database... not put table password. neither user and programmer can not delete table nor take
Insert a row in 'Mysql' table using JSP Code
Insert a row in 'Mysql' table using JSP Code In this section, we will discuss about how to insert data in Mysql database using JSP code. Query...; Mysql database Table. Code to insert row in Mysql table : databaseinsertion.jsp
database backup and restore
database backup and restore  hi i m able to take backup through java code but i m unable to restore the same file through the restore code . please provide me some suggestion
cold backup, hot backup, warm backup recovery
cold backup, hot backup, warm backup recovery  What is cold backup, hot backup, warm backup recovery
In this section you will learn how to rename MySQL database.
into new database Take the backup of database using mysqldump utility... while renaming the database. Before renaming the database take the backup...How to rename MySQL database? In this section we will learn the safest method
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
oracle database backup using jsp
oracle database backup using jsp   I want to take the backup of oracle database.I want to write the code in jsp ,so that when the page is loaded a backup of the database is stored in one of my local drives.Is it possible to do
How to rename MySQL table?
How to rename MySQL table? The designing and development of any software system is a continuous process and you might give a wrong name to a table. After a review you many have to change the name of database. The MySQL database
Database backup
Database backup  I am developing c# application in which i am using Microsoft Access database (OLEdb connections). I want to take backup of database programaticaly. Or as i can tae it in sqlserver 2008 r2(.bak) file. How can i
insert excel sheet into mysql as a table
insert excel sheet into mysql as a table  sir, i want to import an excel sheet into mysql5.0 database as in the table format using tomcat 6.0 by jsp
mysql alter table add multiple columns
mysql alter table add multiple columns  Hi, I have a table in database. I want to add multiple columns into existing table. What is the code for mysql alter table add multiple columns? Thanks   Hi, You can use
oracle data backup
oracle data backup  how to take oracle tables data backup and use in another system
Advertisements
 

 

 

DMCA.com