The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
I am trying to use LOAD DATA INFILE to upload data to my VIP+ SQL Database.
I am not using the LOCAL option so shouldn't I be able to read from a file stored in my VIP webspace?
I can read and write to the database using normal SELECT and INSERT statements but LOAD DATA INFILE gives 'Error = 1045 : Access denied for user ' followed by my database name@localhost
Is LOAD DATA INFILE blocked by Freeola?
If not then has anybody tried this before?
Thanks in advance
I am not using the LOCAL option so shouldn't I be able to read from a file stored in my VIP webspace?
I can read and write to the database using normal SELECT and INSERT statements but LOAD DATA INFILE gives 'Error = 1045 : Access denied for user ' followed by my database name@localhost
Is LOAD DATA INFILE blocked by Freeola?
If not then has anybody tried this before?
Thanks in advance
Thanks Luke
I am developing a shopping site with a database of products.
I think I would update the products once a week, maybe deleting old and inserting new.
This is very much a part-time project and I know from experience that I will have very little time to devote to it, so the more automatic I can make the process the better.
Database sizes will be quite small initially, and the tests I have been doing with INSERTs execute very quickly, so I don't think over-burdening the server will be a problem. I can split the data so that I do not update the database all in one go.
I don't think import speed is going to be as much of an issues as I thought.
I can see a way forward now
Thanks very much for your help.
I am developing a shopping site with a database of products.
I think I would update the products once a week, maybe deleting old and inserting new.
This is very much a part-time project and I know from experience that I will have very little time to devote to it, so the more automatic I can make the process the better.
Database sizes will be quite small initially, and the tests I have been doing with INSERTs execute very quickly, so I don't think over-burdening the server will be a problem. I can split the data so that I do not update the database all in one go.
I don't think import speed is going to be as much of an issues as I thought.
I can see a way forward now
Thanks very much for your help.
Okay so you want to automate INSERTing rows of data? Although we won't be allowing LOAD DATA INFILE for VIP users at this time, you could just create a PHP script to execute remote SQL files, like you stated. Although it might take longer, it is more secure than allowing LOAD DATA INFILE on shared hosting.
You would obviously need some way of controlling how many queries are done at a time, since you might be throttled or warned about over burdening your particular server.
What would be the reason for importing data regularly to your VIP SQL, would you be synchronising with another DB?
You would obviously need some way of controlling how many queries are done at a time, since you might be throttled or warned about over burdening your particular server.
What would be the reason for importing data regularly to your VIP SQL, would you be synchronising with another DB?
Thanks Luke
I can import using phpMyAdmin but the file size is limited to 2mb at a time.
Although I can split my data in to 2 mb chunks I would still need to import manually, and set the various import options manually every time.
I want to automate the import as much as possible.
It is likely that my data will be changing often and ideally I want to remove as much manual operation as possible.
I am trying to use LOAD DATA INFILE from a php script.
If LOAD DATA INFILE is blocked then I will have to try using INSERT statements for each block of data instead (which does seem to work), but I understand this can be up to 20 times slower than LOAD DATA INFILE.
If there is no way of using LOAD DATA INFILE from a php script then I would rather know now so that I don't waste time developing scripts to use it.
Thanks
I can import using phpMyAdmin but the file size is limited to 2mb at a time.
Although I can split my data in to 2 mb chunks I would still need to import manually, and set the various import options manually every time.
I want to automate the import as much as possible.
It is likely that my data will be changing often and ideally I want to remove as much manual operation as possible.
I am trying to use LOAD DATA INFILE from a php script.
If LOAD DATA INFILE is blocked then I will have to try using INSERT statements for each block of data instead (which does seem to work), but I understand this can be up to 20 times slower than LOAD DATA INFILE.
If there is no way of using LOAD DATA INFILE from a php script then I would rather know now so that I don't waste time developing scripts to use it.
Thanks
I would advise Importing data using the "Import" feature within phpMyAdmin. How are you currently trying to run your SQL, using PHP or through phpMyAdmin?
Incase you are not using phpMyAdmin you can find it by clicking "Manage" next to your VIP database username and password as listed in your MyFreeola account.
Incase you are not using phpMyAdmin you can find it by clicking "Manage" next to your VIP database username and password as listed in your MyFreeola account.
I am trying to use LOAD DATA INFILE to upload data to my VIP+ SQL Database.
I am not using the LOCAL option so shouldn't I be able to read from a file stored in my VIP webspace?
I can read and write to the database using normal SELECT and INSERT statements but LOAD DATA INFILE gives 'Error = 1045 : Access denied for user ' followed by my database name@localhost
Is LOAD DATA INFILE blocked by Freeola?
If not then has anybody tried this before?
Thanks in advance
I am not using the LOCAL option so shouldn't I be able to read from a file stored in my VIP webspace?
I can read and write to the database using normal SELECT and INSERT statements but LOAD DATA INFILE gives 'Error = 1045 : Access denied for user ' followed by my database name@localhost
Is LOAD DATA INFILE blocked by Freeola?
If not then has anybody tried this before?
Thanks in advance