How to Generate Database Script in Mysql in Ubuntu?

amritpalpathak · 11-30-2012, 10:45 AM

I am using ubuntu 12.04 having mysql installed.I need to make a script of database named 'information' including its all tables and data so that i can execute it on other Systems and can get everything as it is.
Can anyone please tell me terminal command for that ?
Thank you in advance.

Habitual · 11-30-2012, 10:55 AM

terminal >

Code:

sudo mysqldump -uroot -p information > /path/to/information.sql

at the other end:

Code:

sudo mysql -uroot -p information < /path/to/information.sql

amritpalpathak · 12-01-2012, 10:33 AM

I used this command

sudo mysqldump -u root -p Shoppingportal > /var/www/information.sql;

And it gave me following error.Can you please tell why?

bash: /var/www/information.sql: Permission denied

Habitual · 12-01-2012, 08:09 PM

Quote:

I used this command

sudo mysqldump -u root -p Shoppingportal > /var/www/information.sql;

And it gave me following error.Can you please tell why?

Not sure, but I have a feeling that it's either the ";" in command or the redirect (">") (sudo+redirect could be 'iffy')

Try

Code:

sudo mysqldump -u root -p Shoppingportal > /var/www/information.sql

or quite possibly

Code:

sudo "mysqldump -u root -p Shoppingportal > /var/www/information.sql"

chrism01 · 12-03-2012, 02:01 AM

I wouldn't normally recommend writing a DB dump to the web docs area; is this being called via php from Apache by any chance?