Database and updating database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mamoman
Forum Newbie
Posts: 5
Joined: Sun Mar 19, 2006 6:18 am

Database and updating database

Post by mamoman »

Hello,

I have a mysql database with 3 rows in a table

airport airline date


the data I import is about 10MB in size.

Everyday I need to update the database.

I want to have this all in PHP.

Currently I am running ASP.net with IIS and MSSQL it erases the database every night at 3 and after that I connect with EMS import to import the new data. this works good, but as ASP.net is not common to be supported by hosting providers I want php.

I have ftp access to my ISP and one mysql database, the phpadmin upload has a limit of 8MB.

I know how to setup the rows and stuff in MYSQSL, the part I need help with is how to update it at night .

Any Ideas ?


/Martin
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

cron?
mamoman
Forum Newbie
Posts: 5
Joined: Sun Mar 19, 2006 6:18 am

Post by mamoman »

I don't have shell access.

/Martin
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Your control panel may be able to set up a cron, you may be able to use php to set up the cron, or your host may be able to set up the cron for you or give you shell access to do so on your own.
mamoman
Forum Newbie
Posts: 5
Joined: Sun Mar 19, 2006 6:18 am

Post by mamoman »

Thnx, but I solved it allready.

Found a hosting provider with ssh access (root) and all kinda tools.

/martin
Post Reply