Page 1 of 1

Database and updating database

Posted: Sun Apr 30, 2006 3:31 pm
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

Posted: Sun Apr 30, 2006 3:43 pm
by feyd
cron?

Posted: Sun Apr 30, 2006 4:11 pm
by mamoman
I don't have shell access.

/Martin

Posted: Sun Apr 30, 2006 8:30 pm
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.

Posted: Mon May 01, 2006 2:56 pm
by mamoman
Thnx, but I solved it allready.

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

/martin