Importing big sql files into mysql
Run phpmyadmin on the server. select database
Choose export. Quick is OK
Open windows file manager
locate the saved sql file. Look in downloads.
Copy to the root of c drive
run x-ampp on the laptop
on a browser goto localhost, choose phpmyadmin
Choose databse syndetic.
Choose Structure.
Scroll down and check the select all box
In the drop down box, choose drop. Click yes
On the XAMPP Control panel choose Shell
# mysql -u root -p syndetic < c:\syndetic.sql
wait as it is a big file
No comments:
Post a Comment