search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

Import from DB - Server response: Service Unavailable #279

Closed BPMspace closed 5 years ago

BPMspace commented 5 years ago

Hello

I'm trying to import an existing SQL DB (button Import from DB). The DB user registered in /var/www/wwwsqldesigner/backend/php-mysql has all privileges on the schema %. The user is NOT root but a specially created user "wwwsqldesigner" . I'm using MariaDB.

"Save" to the DB with server backend php-mysql works. Also "List" and "Load"

But "Import from DB" gives me the message : "Server response: Service Unavailable".

What am I doing wrong? Thanks for the help.

rob

PS As fare as I know can all DB users read from information_schema, or?

BPMspace commented 5 years ago

I found it! there is a second definition for the credentials named "setup_import" in the index.php

Just as Info & THANKS !