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