Jul 9, 2008

Save Database To Harddrive - Save database to harddrive

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Save Database To Harddrive - Save database to harddrive

sader
Is it possible save database from this server to my harddrive unsure.gif or not
I couldn't find right opration in myPhpadmin.
I found "export" button in this tool but there are so many options
and I am a little afraid to use it becouse I don't want to loos my data
(actualy I wan save it wink.gif ).
Or maybe it can be done throuth ftp browser?
There are a lot of defoult folders (I even don't know for what are thay. I know just bublic_html) on my site location so maybe my data are holdet there... blink.gif
So is there way to save my databases sad.gif

Thanx in advice

 

 

 


Reply

BuffaloHELP
You can backup your database and download into your harddrive. Will that work for you? I'm not proficient with database (I just don't trust anything that's out of my reach although TRAP17's been really reliable) so I don't have the working experience. But I'm sure our members can lead you to the right place.

You will see it in the cPanel > phpMyadmin > export

and use the option Save As File. When you are saving as a file (select the file type) you will not disturb any current database.

Reply

guangdian
just phpmyadmin can do it
you can just upload sql to it or just download all sql to your disk

Reply

tigen28
Yeah, to export your mysql database, select the name of your database and wait for the options to load.

Then, select the export tab. If i remember correctly, all the default selection are alright to use; so all you have to do is type a name for the saved file to be and click "SAVE"

It should be in .sql file type. Take note of where the file is saved to and download it to your computer using an ftp program. You can also saved it through your browser it think, but i'm not sure how you can save it as .sql file extension.

Well, at least I'm pretty sure the ftp program will download it for me.

Reply

cse-icons
yup,

Follow these steps to backup:
Go to phpMyAdmin, select the database u want to backup.
Then select the "Export" tab.
Select the tables that u want to backup in the Export combo box, use control to select multiple or select all if u want all the tables.
Check "Drop Table" and "If not Exist" boxes in the structure section.
*This means that it wud add a statement to drop an existing table if it exists when u use this backup for restoring data.
*The "if not exist" clause would create the table if it does not exist or has been dropped.
****chek the "Drop Table" box only if you do not mind losing data that might have been added since last backup****
The "If not exists" is a harmless clause.
Check the "Complete Inserts" box in the Data section.
check the "Save as file" checkbox and click on "GO".
The export sql file will be generated and you will be prompted to save it to ur disk.
U r done with the backup.
IF u want to restore from this file, just go to import, browse to this file and run it.. The whole set of sql statements in the file will execute and the data in the selected tables will be restored.

Cheers.

 

 

 


Reply

eXtreme
Hmm.. I don't backup my mySQL databases like that, i use cPanel.

Here's what you need to do:

1. Open your cPanel page and fill your login details, then go to "Backup" section;

2. Then look for the "Download a MySQL Database Backup" section. There should be your mySQL databases, ordered by name.

3. Just click on one of them to download. wink.gif

If you need to restore the backup database:

1. Login again to cPanel and access the "Backup" section;

2. Look for the field called: Restore a MySQL Database. Browse to your backup database location and hit "Upload".

3. There you are, you've succesful uploaded your previous mySQL backup database.

Last note, you can do in the "Backup" page, full backups of the website, featuring all the files and cpanel configuration. Now the "Full Backup" does NOT backup your mySQL databases.

So you'll have to download always your databases separatly of your main site backup.

Just a small warning. wink.gif

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. create table only "if not exist" postgres - 570.21 hr back.
Similar Topics

Keywords : database harddrive database harddrive

  1. Phpmyadmin - Create new database: No Privileges (6)
  2. I Need Help Transferring Sql Database? - (3)
    ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
    database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
    QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia`
    DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access
    denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to
    give my user all rights, but it gave me this also. QUOTE SQL query: GRANT A...
  3. Changes In Phpmyadmin - Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ...
  4. How To Crate Mysql Database? - urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ...
  5. Need Help With My Database - I cannot transfer my old site's database (19)
    I Couldn't import my database info via Import from php my admin and i got the .sql file from the
    php my admin of my old hosting and every time i try to import it give me an error that i don't
    have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" /> What shall i do?? I need Help Please...
  6. Installing Phpbb - database problem (0)
    Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
    the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
    is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
    connect to the database Im not sure why this has happened as i have never really used mysql for
    ...
  7. Database Connection Problem - phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?...
  8. Database Errors! - Started after HDD change.. (5)
    Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
    refresh site, they not that often but still i get them. It says "could not connect to database". And
    i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
    database! This is a notice email to let you know that SMF could not connect to the database,
    contact your host if this continues. so i am contacting my host.....
  9. Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
  10. Database Is Deleted - database is deleted today (6)
    Today ,I access to my website and It can't connect to database,so I came to cpanel and I saw
    that my database is deleted.I have a question here ,why do my database is deleted?...
  11. Trap17 Database Problems? - (10)
    is it just me or is trap17 having issues now adays? for the past two days the forums have basicly
    been down except for a small period of time last night and just starting like 5 minutes ago..... is
    it just me, or is everyone getting this?...
  12. Mysql Database Problem - appears to be deleted, but still has data (6)
    Hello. My Mysql databases appear to have been removed off of my account, yet according to my
    cpanel, space is still being used on databases. Hopefully I haven't lost any of my data,
    because I haven't taken a backup after recent updates, but If I have, I'll have to make do
    with previous backup. Any idea what's wrong? Here's a quote from my cpanel QUOTE
    Mysql databases 0 / 99 PostgreSQL Databases 0 / 99 Disk usage 13.16 / 150.00 MB SQL
    Disk usage 2.99 MB As you can see, my database data still appears to be on the system, b...
  13. Recommand A Good Database Module Or Component On Mambo - (0)
    Hi guys, I want to have a database function in my mambo website, and I was wondering if it its easy
    to upload a Microsoft Access database into Mambo or if there is a Mambo Module or Component that
    adds a database feature to the website? My database would be quite large several thousand entries
    and I would like to enable to end-user to cross search on several variables on the database such as
    by 'location' and 'Services offered' so any suggestions on which is the most
    suitable database prog around for my needs? Thanks in advance!...
  14. Is It Possible To Move Only Part Of A Mysql Database - more like copying it and putting it elsewhere (4)
    Ok, well on my forums, i have two different forums, one for Role Playing (Harry Potter Role Playing
    not $3x) and the other is for general harry potter discussions, and i added over 100 smilies to
    my rpg forums, and i am guessing that the area that they store the shortcuts for it is in a mysql
    database because i cannot find it anywhere else, and so i am curious if there is any way that i can
    copy the part of the mysql database and move move to copie to the other database, so i dont have to
    enter over 100 shortcuts AGAIN....because i basicly added all of the yahoo me...
  15. Phpbb Forum Installation Problem - Update Database Error (4)
    Guys i was trying to install a phpbb modded forum, i followed this tutorial i had, and was about to
    install it fully when i got this error message An error occurred trying to update the database
    Table 'phpbb_admin_nav_module' already exists If anyone could tell me how to fix this it
    would be greatly appreciated. EDIT: I talked to a friend about the subject and he said i had to
    enter something after phpbb_ in the prefix for data tables or something, so then it came up with a
    file i had to download and ftp to the forum. So once i did that, i tried the forum ...
  16. X7chat2_0_0 Sql Database Privledge Error - (2)
    Im trying to set-up x7chat2_0_0 and i have entered all of the information the correct way, but i try
    to run the install program and it says that i do not have permission to access the database...but
    for the name i have it set for ALL RPIVLEDGES.. any suggestions?...
  17. Mysql Database Problem - (1)
    I was working on my site and the scripts said couldn't connect 2 database so when i went to
    check they were gone and i can't make anymore...
  18. Help With Mysql - Database Parameters (2)
    Hi, I need some help setting up a mySQL. I have install an auto members area script. Now it is
    asking me for the following information: QUOTE Database Host: MySQL host address - localhost
    will work in most cases Database Name: The database must already exist before installation
    Database Username: Username to access MySQL Database Password: Password to access MySQL (this will
    also used as the initial admin login password). I have never set anything like this up before.
    Can someone please help me set this up properly. Thank you....
  19. Database Error - down down... (11)
    QUOTE Warning: mysql_connect(): Can't connect to local MySQL server through socket
    '/var/tmp/mysql.sock' (2) in /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php
    on line 67 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in
    /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 70 ERROR: Cannot find
    database guangdi_i Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
    /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 103 There appears to be...
  20. Database From Astahost To Trap17 - possible? (4)
    Hi all, I just got webspace on trap17. Before I had webspace on astahost, but couldn't get
    enough credits there. I had a forum there. Is it possible to put all what was there to here. I
    tried, but then my forum wants to redirect me to astahost and that's not what I want. Thanks in
    advance, Moody...
  21. Mysql Database Problem ! - (19)
    Ok my site was running like with no problems from the mySQL database for six months even more now it
    was made on PHP - Nuke i didnt touch anything when suddenly yesterday it said that there is a
    problem with the Database and we will be back shortly blah blah blah... anyway the site wasnt back
    about an hour ...i deleted the whole PHP-Nuke installation deleted the mySQL scripts etc etc and
    tried to start everything from scratch... Ne way what i wanted didnt happen... when i installed the
    new php-nuke the same error occured... it said that there are problems with the mySQL...
  22. What's Going On With The Mysql - database error and gd+ problems (6)
    this error is coming up Database error in vBulletin : Link-ID == false, connect failed mysql
    error: mysql error number: 0 I saw the problem the cpu and memory was at overload. Why is that?
    Also our images ain't coming up for gd+ and we had to disable image verification so new members
    can join...
  23. Mysql Database Backup/restore Error - error with restoring backed up .sql file (3)
    hi there, im just wondering if anyone can tell me what is wrong when im trying to restore my sql
    databsse (sorry if this is in the wrong section but i guess this is the only section that i think
    this will fit in) QUOTE SQL-query: CREATE TABLE IF NOT EXISTS `e107_banlist` ( `banlist_ip`
    varchar( 100 ) NOT NULL default '', `banlist_admin` smallint( 5 ) unsigned NOT NULL default
    '0', `banlist_reason` tinytext NOT NULL , PRIMARY KEY ( `banlist_ip` ) ) ENGINE = MYISAM
    DEFAULT CHARSET = latin1 QUOTE MySQL said: Documentation #1064 - You have a...
  24. Cpanel And Mysql Database - My cpanel is busted and sql database (7)
    For some reason i login into my cpanel then it goes all blank... then next thing my mysql database
    shuts down... now i cant fix anything since i dont got cpanel... i cant access anything on my site
    someone please help me....
  25. Finding Mysql Database Password? - please help (6)
    hi, I have installed Coppermine Gallery using fantastico. I want to bridge it with mambo. and for
    that configuration, I need the password for the database Coppermine uses. Can anyone tell me how
    to find out the database password in this case? I tried the coppermine admin panel but could not
    find it there. Does anyone know which config file does coppermine use to store database password. I
    can create another user with the same permissions and use it but there must be a way to determine
    the password set for the databases created by fantastico?? any help would be apprec...
  26. Database Help - (5)
    Hi: I hope somebody can help me with this. I have never used a database or php or mySQL on my site
    before. Totally new at it. I found a great looking greating card program I want to add to my site,
    called Sendcard. I have uploaded it to my site. When I am going thru the installation wizard it is
    asking me for information that I don't know. ---the data base host --- the name of the database
    ---username ---password Do I need to go to cpanel and go into mySQL and set it up? Or is it done
    automatically? Or at least, where is a good online tutorial so I know how...
  27. Sql Database - (2)
    Where do I get my SQL database username and password?...
  28. Detecting New Entries In The Database, Live - (0)
    ok... i got the newline thing solved,ok, i finally got things up and working, the database is fine,
    now there is another problem that i've stumbled accross.... how to detect live,, whenever there
    is a new entry in teh database.. hmm.... tricky.. but i am no good php and mysql as i am brand new
    to the whole concept, so i thought i could do this.. created a continous looped flash movie, and
    have a php code at the beggining.. which counts the no. of entries that are there in the database,
    and then every two minutes, it counts it again, if the new value is greater the...
  29. Trap17 Supply 1 Mysql Database To Freehosting? - (10)
    Does trap17 supply mysQl to Free hosting packages? Because, I would really like one... /wink.gif'
    border='0' style='vertical-align:middle' alt='wink.gif' /> Also, are the ftp's fast? Because
    free hosting packages with ftp, took like 2 hours to upload PhpBB2.0.14... /tongue.gif' border='0'
    style='vertical-align:middle' alt='tongue.gif' /> I have ADSL......
  30. Manual Phpbb 1.0.13 Installation Error - "Could not connect to database" (2)
    Here is the error I received, I have installed phpBB's manually before, and never gotten this,
    can anyone help? Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
    /home/gotya/public_html/phpBB2/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument
    is not a valid MySQL-Link resource in /home/gotya/public_html/phpBB2/db/mysql4.php on line 331 phpBB
    : Critical Error Could not connect to the database...



Looking for save, database, harddrive, save, database, harddrive

Searching Video's for save, database, harddrive, save, database, harddrive
advertisement



Save Database To Harddrive - Save database to harddrive



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE