FreePgs.com Forum
October 25, 2021, 07:27:38 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Donate to FreePgs.
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: How to restore/import MySQL database  (Read 2797 times)
tle
Non-Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 3

Blog entries (0)

View Profile
« on: May 04, 2006, 01:07:02 AM »

Hello,
I am very new here and I want to ask if any one can show me how to import/restore my MySQL database to the server. I think I can no use phpmyadmin because the database file is about 70MB. Do we have access to SSH or something similar so I can do an import in command-line? Also, can I store the whole content of my site in the database instead of files (approx. 100-200MB).
Thank you.

Trung Le
Logged
sixthcrusifix
Sage
Verified Account
Sr. Member
*

Karma: +0/-3
Offline Offline

Posts: 445


http://sixthcrusifix.com/home/

Blog entries (0)

View Profile WWW
« Reply #1 on: May 04, 2006, 02:23:26 AM »

how in the bloody hell do you have 70 MB worth of textual data? That's 70,000,000 characters.

anyway yeah I think PHP MyAdmin is pretty much out, I have no idea how you can restore it, the ony way I've accessed my Databases is via PHP MyAdmin.

You could try uploading it to your site and then running your own script (or you could TRY PHP MyAdmin but it won't work I think it can time out)

Is it just one single file that is 70 MB?
Logged

Visite me website at http://www.sixthcrusifix.com
FreePgs.com Forum
« Reply #1 on: May 04, 2006, 02:23:26 AM »

 Logged
tle
Non-Verified Account
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 3

Blog entries (0)

View Profile
« Reply #2 on: May 04, 2006, 09:44:31 PM »

Well, I thought it is easier to store everything in the database so I stored all of the site content (including graphics, text, PDFs etc.) in the database as blob. Backup/restore a site that stores everything in the database is just a matter of uploading about 100KB of PHP files and one single database file. I know with some hosts, you can upload the files to the server and then use SSH to import the database file to your mysql database.

The other alternative is I have to export my database to multiple files before upload it to the server (which I have not figure out an easy way to do yet). Can som one please help ?
« Last Edit: May 04, 2006, 10:04:41 PM by tle » Logged
brainiac744
Verified Account
Sr. Member
*

Karma: +10/-0
Offline Offline

Posts: 403

Blog entries (0)

View Profile
« Reply #3 on: May 05, 2006, 07:05:04 AM »

While logged into your account use the contact form to ask the admin if he'll import the mysql file into your database for you (do this after you've uploaded the file obviously). I'm pretty sure he does that kind of thing on request.
Logged
FreePgs.com Forum
« Reply #3 on: May 05, 2006, 07:05:04 AM »

 Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!