0
votes
0answers
231 views

can we convert postgresql dump to mysql dump thorough commandline?

Can I convert a PostgreSQL dump file into a MySQL dump? I tried but I get syntax error. cd\ c: cd "C:\Program Files\MySQL\bin" mysql -u root -proot pause I run this batch file after I put this ...
0
votes
1answer
156 views

mysqldump asking for password even after telling it the password in the command line option

I am using the following command: mysqldump -alv -h 123.123.123.123 --password=P@ssw0rd --user=UsernameHere --add-drop-table -p DatabaseSchemaName > dump.sql Then it asks me to Enter Password. ...
3
votes
3answers
270 views

Multiple SSH sessions in a single command

I'm trying to copy a database from one server to another. I tried using the following command and it's getting tied up on entering the ssh passwords. If I put in one server's password, it complains ...
4
votes
2answers
1k views

MySQL export tables with prefix from Unix command line

I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_". I do not have access to ...
5
votes
10answers
2k views

trouble backing up large mysql database

I have a wordpress MU database with something like 10,000+ tables for various user's blogs. I need to upgrade wordpress MU to newest version, but want to backup the DB before hand. PHPMyAdmin fails ...