How to upload database in php website

The most troublesome thing about building a website with PHP program is the database, because PHP must use an independent database. Many novices often make mistakes when uploading databases when building websites. Below, the Hefei PHP training editor will share with you:

In fact, PHP files with databases Uploading HTML files is similar to what we are used to. Just use the file upload function that comes with dreamwaver, or other ftp software. Upload the file according to the directory structure under the root directory of your computer's main website. Can.

You can see three automatically generated folders in the root directory of your website: Connections, _mmServerScripts and _notes. All files in the first two folders must be uploaded to the server. _notes is up to you. , it is mainly responsible for the "remove/deposit" function. If you want to use this function, then upload it.

1: Open the php file in the connections folder with dreamwaver, and change the mysql address, account, and password (these are all on your own machine) to the address of the server you want to upload to. (Generally it is the website address, note: do not use http://www.buleidea.com but www.buleidea.com), account number and password!

Two: Then you can upload all the files of the site to the server.

Three: Then there is the trouble of the database. There are two ways to upload the database:

1.1 If you are the administrator of the server, you have permission to directly access the mysql installation directory on the server, then you only need to upload the mysql/data/ file on your own machine Just copy the files in the folder to the corresponding folder on the server. (That's it that simple. At first, I thought it was very complicated, and I wanted to have any path problems. In fact, mysql's data connection has its own definition, that is, it is connected directly with the database through the server. Or to upload a file, you need to stop the mysql of the server first, and then restart mysql after the upload is completed! :)

1.2: If you are not the server manager, it doesn’t matter. You can use phpmyadmin on your own machine to manage the database on the server. The operation method is the same, but

you edit first phpmyadmin's config.inc.php, plus a set of mysql server address, account and password. As follows

$cfg['Servers'][$i]['host'] = 'Server address';$cfg['Servers'][$i]['user'] = 'MySQL account';
$cfg['Servers'][$i]['password'] = 'password';

Then follow the same steps as building a database and tables on your own machine, and re-create all your tables on the server. Build it on mysql (it may be a bit troublesome)

Okay, you are afraid of trouble, right? Let me tell you another method, which was just taught by a colleague:)----------First use phpmyadmin to connect yourself For the database on the machine, when you enter a table, you can see a dump below, OK, we will dump it;

1 Click "Pour" 2 Select the "sql" method, Other parameters are designed by default         3 Click "Save as file"
    4 Click "Execute"
Then save it anywhere, so you will get a *.sql file

Now we have to pour, now pour Go into the server

    1 Use phpmyadmin to create a table with the same name as you poured it out on the server machine       2 Then select it,
    3 Do you see the four small icons on the navigation bar on the left side of the page? Click on the second icon (I don't know what version you are using, but you can try both), then a window will pop up, and then it is obvious that you click "Import File", then click "Browse" Select The file you just dumped out and then executed will be ok! !

The above introduces how to upload a database on a PHP website, including relevant aspects. I hope it will be helpful to friends who are interested in PHP tutorials.