php+mySQL help..

[the.kaushik]

i have made a website using php and mysql in fedora core 3
now the question is if i want to give it to some one else how do i take the whole setup and give him..

[mehulved]

I guess you need to give that person the mysql database. But, if you explain more about your site, someone with a better idea should be able to help. Is it some CMS or a self coded site? And also which version of mysql and php are both of you'll using. It may turn out that there is an incompatibility between the versions, so just to make sure.

[mediator]

Giving the whole system is very easy!

1. Copy the site,php/html pages
2.

Backing up via the command line

To backup from the command line of your shell account, log in and type the following at the prompt replacing USERNAME and DATABASE as described previously:

mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql

You will be prompted for your database password and then the DATABASE will be dumped to a plain-text file called FILENAME.mysql.

The resulting file, FILENAME.mysql, is a full backup with which you can fully restore your database in case of problems.
Restoring via the command line

Restoring from FILENAME.mysql is a three step process:

1.

Drop the database

mysqladmin -u USERNAME -p drop DATABASE
2.

Recreate the database

mysqladmin -u USERNAME -p create DATABASE
3.

Import the backup data

mysql -u USERNAME -p DATABASE < FILENAME.mysql

Check this (http://www.sixapart.com/movabletype/docs/3.2/01_installation_and_upgrade/mysql_backup_restore.html)

[the.kaushik]

Giving the whole system is very easy!

1. Copy the site,php/html pages
2.

Check this (http://www.sixapart.com/movabletype/docs/3.2/01_installation_and_upgrade/mysql_backup_restore.html)
wow! thanks hope this work