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

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)

SEARCHING USING AJAX IN RAILS

E: Package 'aptitude' has no installation candidate

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP