Can someone please help

[Ritesh]

Quote:

load a database file to my database server.

If you have your database backup in SQL scripts ( created using MySQLDump etc. ), then you can use Tools->Execute Batch Scripts… option to execute your queries from the file. The file can be of any size ( limited by OS ).

[diehl]

I don't want to be a nusance since I don't know anything about mysql or about using webyog. So if you could please bare with me since I am a novice at creating mysql databases.

I was able to connect to the database server through the webyog software and I can see that there are no tables loaded. I have this perl script that uses a database and the person that wrote it installed the database on another website of mine. I connected to that database server using your software and I was able to see all the tables he had uploaded. Now I want to upload the script to another website but I don't know how to upload the database since he had done it for me before. My webhosting provider will not upload the database for me and so I don't know what to do.

So, how do I upload the .db file using your software? I don't have any mySQL scripts all I have is the actual cgi script, the html files, and the database file. Is there a way I can upload the .db file I have to my database server location using the webyog software? Please say there is a way to do this. I greatly appreciate your prompt response and generous support.

Thanks again.

[CalEvans]

That's going to be kind of rough. SQLyog will not utilize the .db file, nor will it execute the cgi script for you to create the database.

if the database you want to create is exactly the same as the one that currently exists on another server, you could use SQLyog to generate the DDL (the SQL to create the database) then connect to the new server and execute it.

I've done this many times without incident.

HTH,

=C=

[diehl]

Thanks very much for your help. I appreciate your responding to my inquiry.

[Author]

Posts