Page 1 of 1

Upload MySql to the server

Posted: Mon Feb 07, 2005 12:25 pm
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

Posted: Mon Feb 07, 2005 12:28 pm
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.

Posted: Mon Feb 07, 2005 3:27 pm
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

Posted: Mon Feb 07, 2005 3:29 pm
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.

Posted: Mon Feb 07, 2005 3:31 pm
by Rmias
Ok thanks I will check their site,

thanks for the help