Jump to content


Photo

MYSQL database uploading


  • Please log in to reply
8 replies to this topic

#1 baber_abbasi

baber_abbasi
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts
  • LocationPakistan

Posted 07 March 2003 - 12:34 PM

Hi,

I am having problem in uploading \"MYSQL database tables\" from my hard drive to a web site.

I am given with username and password and also database availability.

Please give me comments to solve this problem.

Thanking you,


Baber N. Abbasi
baber_abbasi@yahoo.co.uk
Baber N Abbasi

#2 deathead

deathead
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationSunrise/Coral Springs FL, USA

Posted 07 March 2003 - 02:40 PM

Can you tell us any error message you are getting?
~Deathead [br]"You know a conjurer gets no credit when once he has explained his trick and if I show you too much of my method of working, you will come to the conclusion that I am a very ordinary individual after all" - Sherlock Holmes

#3 Iklekid

Iklekid
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationUK

Posted 07 March 2003 - 02:50 PM

Are you trying to set up the databse with a .sql file you have on your hard drive? If so you should run it using some Admin facility like PhpmyAdmin
Webmaster of Dark Wars
[br]http://www.dwog.net

#4 deathead

deathead
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationSunrise/Coral Springs FL, USA

Posted 07 March 2003 - 03:14 PM

Iklekid, you make a good note. and I would like to bring to attention a little something to everyone posting, (or at least the people who are going to read this post.) If you want us to help you, please be as descript as you can. What is the issue here? Is baber not able to backup or does baber not know how to backup? These are two very different issues.
Please baber, tell us what the question is.
Do you not know who to make the backup?
or are you getting errors while trying to back up.
~Deathead [br]"You know a conjurer gets no credit when once he has explained his trick and if I show you too much of my method of working, you will come to the conclusion that I am a very ordinary individual after all" - Sherlock Holmes

#5 baber_abbasi

baber_abbasi
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts
  • LocationPakistan

Posted 08 March 2003 - 06:36 AM

I have taked hosting that support PHP and MYSQL.

The problem I am having is I never uploaded MYSQL fucntioned site before. You can say its new to me to upload database driven site having MYSQL support.

What I want to know is how should my databse including tables and their data will be loaded on the site.

I hope now the problem is explained in detail and do let me know if it\'s not clearer to you.

Please help me solve this problem.

Thanks
Baber N Abbasi

#6 Iklekid

Iklekid
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationUK

Posted 08 March 2003 - 11:44 AM

Do you have Phpmyadmin installed on your webhost? If not i recommend you get it!

Once in there you can manage all of your tables instantly!

To do what you are saying in uploading a table with data then you can simply copy and past the text inside the .sql file into phpmyadmin or upload the file! It will then run and bingo you have your database up :-)
Webmaster of Dark Wars
[br]http://www.dwog.net

#7 baber_abbasi

baber_abbasi
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts
  • LocationPakistan

Posted 08 March 2003 - 12:12 PM

Hi iklekid

Thanks for ur help.

Phymyadmin is installed on the web site. Tell me how should I upload table already created in MYSQL. Should I need to copy and paste and database files from the hard drive or I have to write sql commands in my script.

Please comment.

Thanks again
Baber N Abbasi

#8 Iklekid

Iklekid
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationUK

Posted 08 March 2003 - 01:01 PM

ok go to phpmyadmin Create a databs (unless you already have one) if so from the drop down list on the left select the databse.

When the new page loads go to SQL

You will see a large text box either paste the contents of .sql file into there (open the file with notepad) or clcik on browse and select the file from your hard drive! then clcik run! It will then execute the commands in the .sql file and install the tables and data into your databse!

Iklekid

PS would be wise to back up any of your databses jsut in case you make a mistake :)
Webmaster of Dark Wars
[br]http://www.dwog.net

#9 baber_abbasi

baber_abbasi
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts
  • LocationPakistan

Posted 11 March 2003 - 11:31 AM

I didn\'t mean that to store data at my local PC.

I am going to upload my web site and it uses some tables. Please tell me how should I create these tables at my hosting server.

I think it is more clearer.

Please tell.
Baber N Abbasi




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users