/    Sign up×
Community /Pin to ProfileBookmark

Uploading Database

If I create a database on my computer for a site, is there any way I can upload it to an online server?

to post a comment
PHP

4 Comments(s)

Copy linkTweet thisAlerts:
@GenixdeaeAug 15.2005 — if it's MySQL i'd suggest jus getting a *.sql output....You can get PHPMyAdmin installed and that'll walk you through it or on mysql.com in their documentation they have a way to get an output

[URL=http://dev.mysql.com/doc/mysql/en/backup.html]Here[/URL] is a link
Copy linkTweet thisAlerts:
@ShrineDesignsAug 15.2005 — you can grant access so that other machines can run queries on your database, you'll need either a static ip or obtain a dns name from no-ip.com or mydns.com (both are free)
Copy linkTweet thisAlerts:
@Mr_Initial_ManauthorAug 15.2005 — What I'm trying to do is upload a database from my computer to my website. I'm not always online, so using my own computer as a server is pretty much useless.

What I am asking is can I create a database for a site, and upload it to my site, the same way I can do with an HTML file?
Copy linkTweet thisAlerts:
@GenixdeaeAug 15.2005 — what [B]I[/B] would do is use PHPMyAdmin to make me sql file which will contain all the information i'd need to rebuild the database...Odds are your host has PHPMyAdmin installed(or gives you the option to install it), if so you can jus log into phpmyadmin on your host and have it execute the sql file that was created from your local machine....if it DOESN't have phpmyadmin then you can always format the sql file to be run as a php file and you can jus have the php file run the scripts

that's what i'd do....i tried doing a copy of the mysql db files before(from one comp to the other) and i didn't have much luck...still had to rebuild the database
×

Success!

Help @Mr_Initial_Man spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...