upload MySQL DB onto the server

Hi guys,I have just finished creating a small website.I've used php and MySQL databse {used PHPmyAdmin,xampp thingy}.Everything thing is workin fine in my local machine,but now I need to upload the databse onto the server in such a way that the php scripts can work with the database.The php scripts that do not interact with database are working fine,I have uploaded them onto the sever [they are for sending auto emails].


Please guys help,I have created a database file using mysqldump

Use your XAMPP version of phpMyAdmin to dump your database (is the export function). Then, use your webhost's version of phpMyAdmin to import to your sites DB. This is presuming that your webhost has phpMyAdmin setup for their users an almost all do

I have dumped the databse using the export function.I'm now busy tryin to down load MYPhpAdmin {web host version}.I've using my own domain.

I'm busy taking baby steps,i'll definatetly ask 4ur help again,thanks

It's me again.I just downloaded PHPMyAdmin.been trying to google about how to set it up."Create a DB using cPanel" that's what I read,I dont know where to find the cPanel.I've got smartFTP and it's been seet up.Someone helped me to set it up.I'm not familair with web hosting settings.

So what kind of information do I have to provide to you guys concerning my problem of uploading the databse onto the server so that I can be able to get help from you guys.

really appreciate your help guys,thanks again

>>>>>>>>>>>>
So what kind of information do I have to provide to you guys concerning my problem of uploading the databse onto the server so that I can be able to get help from you guys.

really appreciate your help guys,thanks again


M.A Mtiya
<<<<<<<<<<<<<<
1: Just Upload the unzipped phpMyAdmin to your server (use the same directory structure as was unzipped)
2: Read the installation docs. It is quite good.
3: Follow the installation instructions to get it basically set up for use.

OOPS, I missed the cPanel remark. That is an administrative tool your web hosting provider supplies to allow you to configure your website (options, etc) within their hosting solution. However, if you are 'self-hosted' you probably do not have it. And, if you do not have cPanel (some hosting providers do not use it but use their own custom solutions to accomplish the same things), then how you have to 'create the database' depends upon how/where your website is hosted (VPS, self-hosted, hosting provider, etc).

And, I forgot, you could also configure your Xampp installed phpMyAdmin to access your website MySQL (that is the way I have my Xampp setup - I have phpMyAdmin configured for my Xampp installation, and the production website mysql - and when I log in I select which server to connect to).