I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables.
On one page, I use an SQL query to select data from 10 of the tables in the database.
However, when I try to preview the page in a browser, a PHP warning stating that the MySQL engine has run out of memory.
Is there a way of increasing the Memory Cache of the engine, or a way to optimize the performance?
I am testing locally and will be hosted on our existing internal server, for internal users only. The internal server has the same Apache, PHP and MySQL set up as my local installation.
I don't know how to adjust the settings to increase the memory size, cache or idle time (if this is the problem).
I'm also not sure how to backup my SQL database to upload, along with my PHP code, to something like RapidShare for you guys to take a look at.
I hope someone can help on this as it will help me out tremendously!