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

Is it possible to get SQL from server #232

Open tahagg opened 7 years ago

tahagg commented 7 years ago

Hello,

I try to connect my database on a host, I uploaded the files to the host and change this lines accordingto my db from backend\php-mysql\index.php

<?php set_time_limit(0); function setup_saveloadlist() { define("SERVER","localhost"); define("USER",""); define("PASSWORD",""); define("DB",""); define("TABLE",""); } function setup_import() { define("SERVER","localhost"); define("USER",""); define("PASSWORD",""); define("DB","");

But when I try to run the script

Save / Load -> Server backend: php-mysql -> Import from DB

I wrote my database name but it gives the error XML error: null document

Do you have a solution for this ?

ondras commented 7 years ago

Please try opening http://localhost/path-to-your-installation/backend/php-mysql/?action=import&database=DBNAME, replacing DBNAME with your database name. This will probably result in some error page or an empty page. Please consult this page and/or your PHP/Apache error log to see why is the import feature malfunctioning.

tahagg commented 7 years ago

`This page contains the following errors:

error on line 2 at column 1: Extra content at the end of the document Below is a rendering of the page up to the first error.`

and I'm not working on localhost I'm working on a host that I pay

ondras commented 7 years ago

Well, you should view the page source to see what was actually generated. Or use a tool like curl or wget to display the URL instead of a browser.