Upload MySql to the server

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rmias
Forum Newbie
Posts: 24
Joined: Wed Nov 26, 2003 11:02 am

Upload MySql to the server

Post by Rmias »

Hi,

I upload all my files to the web server successfully and manage to see the web site. However part of the web site uses php with mysql and I do not have a clue on how to upload the database into the server.

I did some research and I found out I need to use phpMyAdmin. I export the database to structure and data and get the raw sql file. However I do not know in which directory I need to upload this file to the server.

Can someone help me please

Thanks
Rmias
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you don't upload it to a folder on the server, you use phpMyAdmin on the server to import the data from the file.. or you use a LOAD DATA INFILE query to load it if you have it on the server already.
Rmias
Forum Newbie
Posts: 24
Joined: Wed Nov 26, 2003 11:02 am

Post by Rmias »

Hi,

Sorry for my ignorance, but I have used ftp software to upload my files and on the server I only have three folders named htdocs, logfiles and private.

I don't know where to use the phpmyadmin do I need to upload it on the server? or should I contact the hosting company. and how do I access the phpmyadmin?

Thanks again
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

most hosts have phpMyAdmin or a similar tool already installed if they offer MySQL databases. You may want to read through the FAQs on your host's support area.
Rmias
Forum Newbie
Posts: 24
Joined: Wed Nov 26, 2003 11:02 am

Post by Rmias »

Ok thanks I will check their site,

thanks for the help
Post Reply