|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Saving/dumping MySQL database
Hello. This is my first post. I did a search how to save a mysql database and i got the answer. then i went to save it, and i got many options how to save the database. in the phpMyAdmin documentation they are not explained, or i did not find the explanation.
what do those options mean? i posted a gif file. its a screenshot |
|
#2
|
|||
|
|||
|
I do not use PhpMyAdmin but I can tell you if you want to export you can use:
mysqldump -u<user> -p<password> -h<host> -B <database> --opt > backup.sql and if you want to import you can use mysql -u -p -h < backup.sql |
|
#3
|
|||
|
|||
|
And where I have to type that? I do not have telnet/ssh access if I am correct. Only via phpmyAdmin.
I will email my host. Last edited by faceFNape : June 30th, 2003 at 09:32 AM. |
|
#4
|
||||
|
||||
|
Why didn't you post this question in the appropriate (MySQL) forum?
You could get more&better answers ... |
|
#5
|
|||
|
|||
|
Those commands are run from the command line.
|
|
#6
|
|||
|
|||
|
well, i have only phpmyadmin access to my database.
still no answer for my questions, thanks every1. i posted here becasue i thought mysql is for syntax problem and this is kinda general problem. |
|
#7
|
|||
|
|||
|
You can use the PHPmysqadmin export tab to export either a table or the entire database.
|
|
#8
|
|||
|
|||
|
Yes Victor, I know. But what do those options mean? That is my main question. Check the attached gif file.
|
|
#9
|
|||
|
|||
|
Structure only: DDL only no data
Structure and data: DDL and statements to populate tables Data only: Statements to populate tables only Add `drop table`: Will drop the table if it already exists Complete inserts: Each insert statement will be atomic. One per line. Extended inserts: will insert multiple values per statement. Use backquotes with tables fields' names: Will quote tables and fields to preserve names. |
|
#10
|
|||
|
|||
|
thanks
|
|
#11
|
|||
|
|||
|
Does that answer your question?
|
|
#12
|
|||
|
|||
|
yes it does
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Saving/dumping MySQL database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|