Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Uploading Data from Computer to MySQL Database
Old 05-01-2005, 04:53 PM Uploading Data from Computer to MySQL Database
Experienced Talker

Posts: 34
Trades: 0
After searching the forums, I've caught glimpses of this, but I'm not sure I've found an answer...

Is there software (Like MS Access or MySQL) that will allow me to upload/delete/edit data from my computer to a MySQL database on a remote server? I would perfer to do this in Access, as I know how to use that software, but I'm more than willing to try out new things.

Thanks,

Andrew
mtairhead is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 05-01-2005, 05:09 PM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
there is this or do a Google search for "MySQL GUI" (no quotes)
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 05-01-2005, 06:20 PM
Experienced Talker

Posts: 34
Trades: 0
Thanks...

I downloaded and installed. I was then told, however, that GoDaddy, my host, does not support the software. When I inquired further, tech. support told me that they do not support any software that would allow me to edit mySQL databases outside of their interface. (I think they use PHPADMIN)

Does this sound right? Does that suck, or what?

Andrew
mtairhead is offline
Reply With Quote
View Public Profile
 
Old 05-01-2005, 08:20 PM
leavethisplace's Avatar
Ultra Talker

Posts: 297
Trades: 0
Why can't you just use PHPMyAdmin ?

And yeah it sounds right, not all servers want GUI, it can cause security risks - especially when you're as huge as GoDaddy.com
__________________
A lie gets halfway around the world before the truth has a chance to get its pants on. - Sir Winston Churchill

Please visit my sites:
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
leavethisplace is offline
Reply With Quote
View Public Profile
 
Old 05-02-2005, 06:06 AM
0beron's Avatar
Defies a Status

Posts: 1,832
Location: Somewhere else entirely
Trades: 0
If you can export from access or excel into Comma Separated Value format then you can use phpMyAdmin to import that data into a file.
__________________
UPDATE 0beron SET talkupation = talkupation + lots WHERE post = 'helpful';

Please login or register to view this content. Registration is FREE
(aka MSN handwriting for forums)
0beron is offline
Reply With Quote
View Public Profile Visit 0beron's homepage!
 
Old 05-02-2005, 11:19 AM
Experienced Talker

Posts: 34
Trades: 0
Thanks.

I'd like to use PhpAdmin, but I was hoping to automate the process, as this database will be updated as much as six times a day. If I can set up a computer to automatically update the mySQL database every 2-4 hours, it would be perfect.

What do you think? Can I automate with PhpAdmin?

A quick solution that I came up with: I can program a Visual Basic routine that copies a file to the server...Why not just store the information in a flatfile? Then, the info can be updated and copied to the server. The old file can be deleted, and replaced. Security isn't really a concern, as this is public information anyway.

Andrew
mtairhead is offline
Reply With Quote
View Public Profile
 
Old 05-02-2005, 01:37 PM
0beron's Avatar
Defies a Status

Posts: 1,832
Location: Somewhere else entirely
Trades: 0
You could write a php script to do the updating, leave that on the server, and then write something that will hit the server with an HTTP request, passing the data along as a post variable?
__________________
UPDATE 0beron SET talkupation = talkupation + lots WHERE post = 'helpful';

Please login or register to view this content. Registration is FREE
(aka MSN handwriting for forums)
0beron is offline
Reply With Quote
View Public Profile Visit 0beron's homepage!
 
Old 05-02-2005, 02:48 PM
leavethisplace's Avatar
Ultra Talker

Posts: 297
Trades: 0
could use a cron job to execute the script too.
__________________
A lie gets halfway around the world before the truth has a chance to get its pants on. - Sir Winston Churchill

Please visit my sites:
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
leavethisplace is offline
Reply With Quote
View Public Profile
 
Old 05-03-2005, 09:23 AM
Experienced Talker

Posts: 34
Trades: 0
Are there any threads or web pages that discuss either of these solutions? I must admit, I don't know how to do either.

Andrew
mtairhead is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Uploading Data from Computer to MySQL Database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 2.57252 seconds with 12 queries