How to depooly a php site with mysql using phpmyadmin?
 

Hi guys i use wamp server and use phpmyadmin for DB, i am done with my web application, how to deploy it in a server, how to export the db and where to import the same. Some help will be surely acknowledged.

I'm a beginner too, but I'd say:

1. FTP all your files to your host
2. Create a new mysql database and user for your host account, then
   
3. (using SSH) Make a copy of your actual database: mysqldump --opt -u databaseuser -p databasename > /path/to/backupname.sql (and upload it to your host)
   
4. then load the copy into the new blank database you created: mysql -u databaseuser -p databasename < /path/to/backupname.sql

Replace databaseuser with the NEW User that you just created in STEP 2
Replace databasename with NEW Database Name you just created in STEP 2
Replace /path/to/backupname.sql with the path where you uploaded a copy of the actual database.

You will be asked for a password. Type in the NEW password as created in STEP 2 and press Enter.

That should be about it :) hopefully someone will say if I've gone wrong somewhere.

What to do?
 

But the problem is i cant create any databases on the server, it says permission denied,the server has phpADMIN too

You don't create a database with the vast majority of hosts, you upload the MySQL dump into the database they made and gave you.
If they didn't give you one, you have to upgrade your hosting package or change hosts.

Remember to match the database connection details of the online version to those given by the host. I keep the details in two files named, say connecton.php and connectlocal.php, but the site will use, say connectme.php When working on my home server, I open connectlocal.php and save as connectme.php. When I decide to upload, I open connecton.php and save as connectme.php. easy peasy. Only one file to update, and no details to edit by hand.

Just go to your own PHPmyAdmin, select your tables and click on Export. That will parse the SQL code with your tables and content.

In your host's PHPmyAdmin go to SQL and c/p the SQL from your own.

Thats the most simple way to do it :3