How to import a sql file in codeigniter?

How to import a sql file in codeigniter?

skunkbad
Senior Citizen
Posts: 1,300
Threads: 63
Joined: Oct 2014
Reputation: 86

10-27-2015, 06:18 PM

If your on Linux your best option is to us exec:

#backup
mysqldump -u username -ppassword database | gzip > ./dumpfilename.sql.gz

#restore
gunzip < ./dumpfilename.sql.gz | mysql -u username -ppassword database

This is going to be the fastest and best way. You could even have it tied into an uploader.

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

Messages In This Thread

How to import a sql file in codeigniter? - by Aloghli - 10-27-2015, 05:11 AM

RE: How to import a sql file in codeigniter? - by Avenirer - 10-27-2015, 05:55 AM

RE: How to import a sql file in codeigniter? - by mwhitney - 10-27-2015, 09:41 AM

RE: How to import a sql file in codeigniter? - by PaulD - 10-27-2015, 11:01 AM

RE: How to import a sql file in codeigniter? - by freddy - 02-16-2017, 09:13 PM

RE: How to import a sql file in codeigniter? - by skunkbad - 10-27-2015, 06:18 PM

RE: How to import a sql file in codeigniter? - by jonathanq - 02-23-2017, 01:42 PM

RE: How to import a sql file in codeigniter? - by ignitedcms - 02-23-2017, 02:58 PM