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’);

Add a Comment

Your email address will not be published. Required fields are marked *