MYSQL IMPORT & EXPORT

Import your database using the following command

mysql -u username -p new_database < data-dump.sql

Export your database using the following command

mysqldump -u username -p database_name > data-dump.sql

Comments

Popular posts from this blog

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

E: Package 'aptitude' has no installation candidate

SEARCHING USING AJAX IN RAILS

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH

SHOW LINE NUMBER OF TEXT AREA