How to Import 1GB .sql file to WAMP/phpmyadmin

Importing Large Database file via Mysql console

• Click your Wamp server icon -> MySql -> MySql console
• Once mysql console is open. Enter your mysql password. and give these commands.
  1. use user_database_name
  2. source c:/your/sql/path/filename.sql

Phpmy admin replace text in one field in one table

A query to replace update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

Example:

update wp_posts set post_content = replace(post_content, ‘capital’,’capitol’);