How to use PHPmyadmin to upload a mysql database to a server space

Source: Internet
Author: User
Tags how to use phpmyadmin
How to use PHPmyadmin to upload a mysql database to the server space I now have a DZ BBS with the MYSQL database. I bought a space. But I don't know how to transfer the database?
There are three folders in the network space: WWWROOT, DATABASE, and LOGFILE. However, the bbs database of DZ cannot be uploaded to the DATABASE folder. you need to borrow PHPMYADMIN to upload the files. some people say there are also Empire backup files. But how to upload the MYSQL database?

The server company told me to use PHPMYADMIN to upload the database. But my food, no?

Which of the following heroes can win !!!!


Reply to discussion (solution)

And the username and password of the database to be allocated to the server company,
You can configure phpmyadmin to complete the import.
Otherwise, they are all white.

And the username and password of the database to be allocated to the server company,
You can configure phpmyadmin to complete the import.
Otherwise, they are all white.

My machine is WIN2003. Do I have to configure PHPMYADMIN on my machine and then import the database?

Reference the reply from jakey9826 on the second floor: and the username and password of the database to be allocated to by the server company,
You can configure phpmyadmin to complete the import.
Otherwise, they are all white.

My machine is WIN2003. Do I have to configure PHPMYADMIN on my machine and then import the database?
Upload phpmyadmin to the space for execution and delete it after completion.
Generally, the user name and password for remote access are not provided.

Generally, the space comes with phpmyadmin and free space. you can find the phpmyadmin link and then import the database from phpmyadmin.

Right-click mysql and select database to convert SQL file to export Database. SQL file first
Access the phpmyadmin address. after logging in, create a database with the same name. Note that the encoding must be consistent. SQL file. Then, enter the address of the database accessed by the program to access phpmyadmin.

Right-click mysql and select database to convert SQL file to export Database. SQL file first
Access the phpmyadmin address. after logging in, create a database with the same name. Note that the encoding must be consistent. SQL file. Then, enter the address of the database accessed by the program to access phpmyadmin.

Do not use phpmyadmin, because when you import SQL statements, it will be restricted by uploading files in php. ini,
We recommend that you use Navicate for Mysql, which has powerful functions and small installation files to meet your needs. of course, this requires the mysql address, user name, and password provided by your space service provider.

By the way, the software name is Navicat for MySQL. I hope my answers will help you.

What I said upstairs makes sense: software that can be used to connect to the database externally

Yes, navicat. I think so.

You can export the database locally as a ***. SQL file,

Upload phpmyadmin to your space,

Http: // www. ****. com/phpmyadmin/index. php

Enter the database username and password that the service provider gives you

Import and select the ***. SQL file.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.