FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Uploading Data Base





Liu
Hi all,

I already have a DB that I backed up using MySQL Administrator, thus a .sql file. How would I go about using this file restore it now on my frihhost DB? Help appreciated - thanks!

-Liu
Bondings
Liu wrote:
Hi all,

I already have a DB that I backed up using MySQL Administrator, thus a .sql file. How would I go about using this file restore it now on my frihhost DB? Help appreciated - thanks!

-Liu

Is the file bigger than a few MB?

Normally you just need to log in to phpMyAdmin with the username/password of the database (first create one of course). And then in phpMyAdmin there should be an option to import .sql files.
Liu
Hmm, the parser doesn't seem to like my file. :\

Is there anyway to use MySQL Admin?

I'm using pixeliuted.frih.net as my server, and port 3306, but no luck.
Bondings
Liu wrote:
Hmm, the parser doesn't seem to like my file. :\

If it's a different mysql version, then it might have a slightly different syntax and in most cases you could edit it by hand.

Otherwise, upload the .sql file somewhere in your account (not public) and tell me where it is. Also mention which database you want it to be in. I'll try it out myself.
Liu
I've uploaded the file to the main directory.

I've only made one DB for my current account; liu_photo. Many thanks for the help. Smile
Bondings
I managed to put it in the database. I removed the default charset (shouldn't cause any problems I hope. I however also had to remove the "on update" of some timestamp.

Please check if everything is fine.
Liu
Everything is working out spiffy; thanks bondings! Smile
Related topics
Hey everybody ;) HTML or Blog?
Booting time
Implementing your database access in PHP as a layer.
submit to search Engine
Protect your PC
Does mysql have a limited!
What are the steps after u format your Hardisk?
HOW TO CONNECT MY SITE TO AN ACCESS DATA BASE??
error: 1146 data base not found some one can help???
mkportal and the phpbb templates
Moving phpBB data base to other Chat Forum
data access page in the internet
how to redirect user to other data base after authnicating
Query your base's size
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.