Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Migrating database from MAMP to AMPPS in El Capitan



Threaded Mode | Print  

 Migrating database from MAMP to AMPPS in El Capitan, how to migrate databases to AMPPS' phpmyadmin (0 Replies, Read 4388 times)
meriyei
Group: Member
Post Group: Newbie
Posts: 1
Status:
Hi all,

After the upgrade to OS X El Capitan I could not start MAMP anymore and decided to install AMPPS. I have configured everything but I cannot migrate my database from the old phpmyadmin to the new one (I can't access to the old one). Tried to export with mysqldump:

mysqldump -u root -p  /Applications/MAMP/db/mysql/blog > blog.sql

but got this error:

mysqldump: Got error: 1049: Unknown database '/applications/mamp/db/mysql' when selecting the database

I have tried with all combinations possible, and also I've tried to move all of them:

mysql meriyei$ mysqldump --all-databases -p /applications/mamp/db/mysql > mysql.sql

I don't get any error but when importing in AMPPS' phpmyadmin, I've got this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Usage: mysqldump [OPTIONS] database [tables]
OR    mysqldump [OPTIONS] --databa' at line 1


Anyway, I don't know if it will work exporting all databases at the same time...

I think it could be a problem that I did not have any password for the root and now I entered in the safe mode to put one. I also tried:

mysqldump -u root -pXXXXX  /Applications/MAMP/db/mysql/blog > blog.sql

being XXXXX my new root's password, but I've got the same error.

So I have to export this db from the old server I was using with MAMP in past versions of OS (Mavericks & Yosemite) to my new server with AMPPS in El Capitan

Thank you in advance! please help!
:cry:
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 8:28 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.275