I was uploading a sql statement of 108MB file to MySQL via phpMyAdmin in on WAMPSERVER. I got “Script timeout passed, if you want to finish import, please resubmit same file and import will resume”. phpMyAdmin then cancelled my upload because it reached time out again
How to solve it?
1. Edit php.ini. You can find it here C:\wamp\bin\apache\Apache2.2.11
2. Use Find tool
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
memory_limit = 8M
Change to:
post_max_size = 110M (see the sql statement filesize above)
upload_max_filesize = 110M
max_execution_time = 1000
memory_limit = 128M (based on RAM)
Save php.ini
3. Edit my.ini, find it here, C:\wamp\bin\mysql\mysql5.1.36\my.ini
4. Use Find tool
max_allowed_packet = 110M
Save my.ini
5. Restart WAMPSERVER
I upgraded WAMPSERVER in a local PC yesterday. The latest WampServer 2.0i includes Apache 2.2.11, MySQL 5.1.36 and PHP 5.3.0.
I was getting this error in the main of phpMyAdmin bundled with WAMPSERVER, The additional features for working with linked tables have been deactivated. To find out why click here
When I clicked the link, it showed this report
$cfg['Servers'][$i]['pmadb'] … not OK
$cfg['Servers'][$i]['relation'] … not OK [ Documentation ]
General relation features: Disabled
$cfg['Servers'][$i]['table_info'] … not OK [ Documentation ]
Display Features: Disabled
$cfg['Servers'][$i]['table_coords'] … not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] … not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg['Servers'][$i]['column_info'] … not OK [ Documentation ]
Displaying Column Comments: Disabled
Bookmarked SQL query: Disabled
Browser transformation: Disabled
$cfg['Servers'][$i]['history'] … not OK [ Documentation ]
SQL history: Disabled
$cfg['Servers'][$i]['designer_coords'] … not OK [ Documentation ]
Designer: Disabled
How to solve that errors?
1. Click Home icon in the sidebar of phpMyAdmin
2. Click Import tab
3. Browse file create_tables.sql in WAMPSERVER Installation folder. It can be found at C:\wamp\apps\phpmyadmin3.2.01\scripts\create_tables.sql. Click Go to start import
4. It creates a database name phpmyadmin
5. Click Home in the sidebar again
6. Click SQL tab
7. Enter this command in Run SQL query/queries on server box, CREATE USER ‘phpmyadmin’@'localhost’ IDENTIFIED BY ‘pmapass’;
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO ‘phpmyadmin’@'localhost’; . Click Go
8. It creates user phpmyadmin for the phpmyadmin database
9. Edit config.inc.php in C:\wamp\apps\phpmyadmin3.2.01\
Add these lines to config.inc.php
/* phpMyAdmin linked table */
$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
$cfg['Servers'][$i]['relation'] = ‘pma_relation’;
$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
$cfg['Servers'][$i]['history'] = ‘pma_history’;
$cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;
$cfg['Servers'][$i]['controluser'] = ‘phpmyadmin’;
$cfg['Servers'][$i]['controlpass'] = ‘pmapass’;
Save config.inc.php
10. Close phpMyAdmin window in your browser
11. Open phpMyAdmin in your browser. The errors should be gone.
# Redirect if NOT www.example.com (exactly) to www.example.com
RewriteCond %{HTTP_HOST} .
RewriteCond %{HTTP_HOST} !^www\.example\.com
RewriteRule (.*) http://www.example.com/$1 [R=301,L]
-or-
# Redirect if example.com (case-insensitive) to www.example.com
RewriteCond %{HTTP_HOST} ^example\.com [NC]
RewriteRule (.*) http://www.example.com/$1 [R=301,L]
I want to do the opposite, i.e. redirect www to non-www
# Redirect if NOT example.com (exactly) to example.com
RewriteCond %{HTTP_HOST} .
RewriteCond %{HTTP_HOST} !^example\.com
RewriteRule (.*) http://example.com/$1 [R=301,L]
-or-
# Redirect if www.example.com (case-insensitive) to example.com
RewriteCond %{HTTP_HOST} ^www\.example\.com [NC]
RewriteRule (.*) http://example.com/$1 [R=301,L]
For use in httpd.conf, change the rule pattern from “(.*)” to “^/(.*)$”.
If the non-canonical www domain already works –that is, if it returns the same content as the non-www domain– then no changes to your ServerName/ServerAlias configuration are necessary.
Fave Design