Jul 31, 20080
Turning MySQL Data to UTF-8
MySQL | PHP | Tutorials & Resources
(No Ratings Yet)
Loading ...Just add below line after MySQL connection is establisted:
mysql_query(”SET NAMES utf8″);
(No Ratings Yet) Loading ...Jul 30, 20080
Import / Restore Large MySQL Data File
(No Ratings Yet) Loading ...A simple 3-steps procedure to import/restore large MySQL data file via command line.
A 200mb data file should take less than a minute to complete.
1. Telnet or SSH to server
2. Login to MySQL
mysql -u user -ppassword
3. At MySQL prompt
use your_database_name
source your_sql_data_file.sql
1
