how to upload database using ftp?

Question

1.00/5 (1 vote)

See more:

I have developed a PHP website and now i want to replace it with existing one which is in HTML.I have ftp username and password of old one but how can I upload my database which is in .sql. Is it possible to upload database using ftp???

Posted 30-Jun-12 18:01pm

Jackin Shah

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Jul-12 3:02am

"Replace PHP Web site with HTML Web site" sounds gibberish.
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2012-06-30T19:14:00

Solution 1

Check with your hosting provider they will show you how to do this with their software.

Posted 30-Jun-12 19:14pm

Mehdi Gholam

Comments

Sergey Alexandrovich Kryukov 1-Jul-12 3:02am

Right, a 5.
By the way, did you notice OP actually wants to replace "PHP Web site" with "HTML Web site"? But the new one is with database as well. I can imagine... :-)
--SA

Mehdi Gholam 1-Jul-12 5:23am

Thanks

Mohibur Rashid · Answer 2 · 2012-07-01T17:18:00

Uploading database using FTP?
Probably not possible for lots of reason:
1. You are not allowed to access database directory
2. Version in compatibility
3. May be database wont support at all
4. You may not have permission to run and execute sql file from command prompt

Create a Full structure of your database(I am talking about mysql) using your phpmyadmin application installed in your machine. then upload that script to the server and run the script from that server. 3 possible ways:
1. Upload sql file using ftp . if you have permission to run msyql client then execute the sql file
2. if you have phpmyadmin access of that server then just use that to upload your sql file and execute.
3. finally you can write a simple php code to execute the sql file. After executing don't forget to remove that php file as well as sql file