473,326 Members | 2,099 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,326 software developers and data experts.

Reading Dump

65
Hi friends,

can anyone tell me how can I read dump values from one database to another?
I can't understand the dump concept properly. can anybody explain it?
what command we have to use to dump tables?

I have to dump one large table from one database to another.
what is the command for it?
Please help me out.

Thanx n Regards
Yas...
Apr 3 '08 #1
4 1382
debasisdas
8,127 Expert 4TB
mysqldump is a tool to import and export MySQL databases.

It can be used to back up a database or to move database information from one server to another.

To export a database.

# mysqldump -u username -ppassword database_name > FILE.sql

Replace username, password and database_name with your MySQL username, password and database name.

Import is used to restore data from a backup or to import from another MySQL server.

Start by uploading the FILE.sql file to the server where you will be running this command.

# mysql -u username -ppassword database_name < FILE.sql
Apr 3 '08 #2
ronverdonk
4,258 Expert 4TB
When you can use phpMyAdmin it is even simpler. Just go to the database panel and click 'Export' tab at the top.

It will prompt you for the names of the tables (or the entire database), and the extra options to generate like 'DROP' and 'IFEXISTS', whether you want to write the sql dump to screen, where you can copy and paste it, or write the dump to a file.

In the latter case, you can then transmit that file to the new database server and do exactly the opposite, i.e. go to the db panel, hit the 'Import' button, and specify the name of the dump file you made previously and run it.

Ronald
Apr 3 '08 #3
yasmine
65
Thanks a lot.... for ur valuable replies......
I'm amazing, how easy these things are......


Thanx n Regards
Yas...
Apr 7 '08 #4
ronverdonk
4,258 Expert 4TB
Thanks a lot.... for ur valuable replies......
I'm amazing, how easy these things are......

Thanx n Regards
Yas...
You are welcome yasmine. See my signature for an explanation of why sometimes things look difficult.

Ronald
Apr 7 '08 #5

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

Similar topics

1
by: Mike Orb | last post by:
Hi. I've successfully installed PHP in the past but am having problems compiling it all of a sudden. To try to fix the problem I downloaded a fresh copy of Apache 1.3.29 and PHP 4.3.5 and kept the...
1
by: fabrice | last post by:
Hello, I've got trouble reading a text file (event viewer dump) by using the getline() function... After 200 - 300 lines that are read correctly, it suddenly stops reading the rest of the...
7
by: Cyril VELTER | last post by:
I'm trying to dump a database from a 7.1.3 server to a 7.4.2 one. It doesn't works because of difference in COPY format (unless I use -d which is VERY slow on a 16G database). What are the...
6
by: Soeren Gerlach | last post by:
Hi, some weeks ago I started to develop an application using Postgresql the first time. I'm running 7.4.3 on a Linux box with a plain 2.6.7 kernel, the storage is handled by 5 SATA disks,...
5
by: Allin Cottrell | last post by:
A. Suppose my program mallocs and populates an array of structs of a fixed size apiece. For example, something like: struct foo { int i; double x; char s; }; We want to save this work and...
1
by: Andrea Gavana | last post by:
Hello NG, that may sound a silly question, but I didn't find anything really clear about the issue of reading unformatted big endian files with Python. What I was doing till now, was using...
1
by: Ghostwalker | last post by:
I'm trying to read out a file, in which some data is stored. Format is this: name < value > ... ; But when I run the following code: std::string token; while (is >> token && token != ";")...
9
by: Use*n*x | last post by:
Hello, I have a binary file (image file) and am reading 4-bytes at a time. The File size is 63,480,320 bytes. My assumption is that if I loop through this file reading 4 bytes at a time, I...
1
by: mthread | last post by:
Hi, Given below is the core dump generated from my application. The issue is, I have compiled my code with -g option . But the core dump show neither the file name nor line number which caused the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.