For creating a dump of a database..i use
"mysqldump -u root -p [database_name]"
But where xactly is the dump file stored!!!!
thanx
nowhere, it's printed to the screen.
If you want to store it, you have to do
mysqldump -u root -p [database_name] > filename.txt
iam done with that.. now can u help me with the pgsql part converting mysql dumps to pgsql and convetting oracle dmp to pgsql thanx in advance
Search on sourceforge.net, there a re a few utilities that let you convert MySQL to pgsql, but you'll have tot change some things about Capitals in your database field names etc.
