support
Archived Posts from this Category
Archived Posts from this Category
To create the database backup, you have three options .
1. Use the cpanel backup option. This is usually the easiest., however the file will be in .sql.gz format. If using this option, you will need to first unzip the file using a program such as winrar, then to open the file, unless you have another program already setup to open it, you would use wordpad.
2. Alternative way:
a. login to cpanel
b. click on mysql databases
c. scroll down and click on phpmyadmin
d. If you have more then 1 database, on the left hand side choose the database you want to download. Do NOT click on any tables for the individual database
e. on the right hand side, click on “export” and make sure that all your tables listed are highlighted.
f. Make sure “save as file” is selected
g. click on “go”
This will allow you to download your database into a .sql file.
3. Another alternative:
Use the same steps as above except on step 6 do NOT “save as file”. This will display your complete database within the browser window, and you can then do a “copy/paste” into a wordpad file. If using this method, if saving the information to your local system, save the file as a .sql in case you ever need to import it to phpmyadmin.
WARNING:
If your Database is excessively large, and you may experience issues with either method above if you have any instability with your connection between your location and the server.
If you continue to experience issues, contact your support, advise you are having issues, and ask if a technician can create a backup and save it to your file structure so that it can be downloaded via browser.
They will usually need the following information:
1. Last four of card on record, account username, account password (this is for ownership verification)
2. Database name, database username, database password
3, Location where you would like the database backup moved to, must be inside public_html to allow for download via browser.
4. Url of this forum, so that they can see the history of this issue
0 comments Monday 29 Mar 2010 | BestHosting | cpanel, mysql, support, tips
PHP Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 8193 bytes) in ….
looks familiar ? This memory limit is dependent on settings inside your php.ini file(which should be inside public_html, if you have created one).
You can change it by editing line 232 in your php.ini file. I would change it to read as such:
memory_limit = 64M
If you haven’t created a php.ini before, follow these steps:
1. Login to cPanel.
2. Click on PHP Config from the Software / Services section.
3. Select PHP5 (Single PHP.INI).
4. Click Save Changes.
5. On this same screen, select IONCube, and click ‘Install PHP.INI Master File’.
6. Go back to the cPanel.
7. Click on ‘File Manager’ from the Files section.
8. Select Webroot and click go.
9. Find php.ini.default and rename it to: php.ini
10. Select the php.ini file and click ‘Code Edit’.
11. Click ‘Edit’ in the lower right hand corner.
12. Scroll to line number 232.
13. Change line 232 to read as such:
memory_limit = 64M
14. Click ‘Save Changes’ (upper right hand corner).
You should now be able to perform operations that require more than 32 megabytes.
About author : This original article is property of Top 10 Web Hosting (http://www.top10webhosting.com). List of best web hosting services company offering PHP and MySQL. Compare & save ! on web hosting fee. Note : Please include author information if you wish to republish this article.0 comments Friday 05 Feb 2010 | BestHosting | php, support
While most hosting company offer 99.9% network uptime but they usually do not offer 99.9% server up-time. Good luck ~
1 comment Friday 21 Aug 2009 | BestHosting | support, tips, tutorial