473,387 Members | 1,483 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

how to backup the table's datas from linux?

65
Dear all,

may i like to know how to backup the datas inside the table in linux platform?

i use mysql software to create table and store datas.

can someone guide me?
Sep 24 '07 #1
3 1341
mwasif
802 Expert 512MB
Use command line utility mysqldump to backup your data.
Sep 24 '07 #2
wish
65
Hi,
after i backup the database by used mysqlhotcopy method to backup. Is it the table datas also still contain inside the table? Cos i saw that the table with the different extensions like .frm, .MYD and .MYI.

After i backup then if the previous data is loss then how and what is the method that i can restore back the datas with my backup?

Thanks.
Sep 26 '07 #3
Hi,

To take the backup of mysql database table, you can use the following "mysqldump" command.....

Syntax:
mysqldump [options] [database_name] [table_name] > <file_store_path>;


Example:

mysqldump -u root --extended-insert test_db sample_table > /home/backup/table_backup.sql


Regards,
S.Ashokkumar
Sep 26 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Spieg | last post by:
I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some...
2
by: Raffi | last post by:
I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? ...
5
by: David | last post by:
I am a little confused by DB2 Backup and Export. I used "db2 backup db QAS to /dev/rmt0" backuping 650GB database to a IBM LTO 3581 (1 drive) only 11 hours. But I used "db2 export to /dev/rmt0...
7
by: slitvinov | last post by:
I am learning Relax NG. The problem is that I cannot figure out how to make a schema for a table. In my case I would like to make a table with any name of child elements (columns) but columns...
6
by: himilecyclist | last post by:
I am trying to use the SQL "SELECT INTO" to create a copy of a MySQL database. My PHP code looks like this: <?php //Connect to server and database include ("Connections/ovrs.inc");
2
by: Lennart | last post by:
We have recently moved a ClearQuest database to db2 V8 on linux. We take a full compressed backup on sundays (~400Mb) and compressed incremental/incremental delta other weekdays. What puzzles me is...
6
by: michael.spoden | last post by:
Hi, how can I fix lock-waits during an online backup? Is an online backup in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux. The command to perform the backup is: db2 backup...
0
by: imagetvr | last post by:
Hello I am using windows XP I need a small programme in Visual basic 6 with Access 2000 I have two tables for example one table named student other table named section In student table...
3
dlite922
by: dlite922 | last post by:
Problem: I want a backup utility for my CentOS 5 HP DL320 G2 server with Software Raid, Gnome installed but I do not want to install every backup utility there is to find the one i'm looking for:...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.