I have ordered a dedicated server running on a linux operating system and I have just installed PHPmyadmin. When I tried to import a backed up MySQL database my backup was too big to import (it is just under 4 megs big).
I have been on the wiki site for PHPmyadmin and it says I could change the max upload size on the import page by adding the following line into the confin.inc.php file:
Expand|Select|Wrap|Line Numbers
- $cfg['MemoryLimit'] = 10000;
Here is my config.inc.php file:
Expand|Select|Wrap|Line Numbers
- <?php
- $i=0;
- $i++;
- $cfg['Servers'][$i]['host']='213.171.218.253'; // your database server’s IP address
- $cfg['Servers'][$i]['auth_type']='config'; // Authentication method – config, http or cookie
- $cfg['Servers'][$i]['user']='northe00'; // your database username
- $cfg['Servers'][$i]['password']='password'; // your database user’s password
- $cfg['MemoryLimit'] = 10000;
- ?>
Thank you for any help