[Ritesh]

Thanks for the info 😀

[Ritesh]

I completely support with nero's view. The best way to keep the Help file for offline viewing is to save the file as .mht on to your hard disk.

[Ritesh]

Are you using SQLyog's Import CSV option? All the queries executed by SQLyog are listed in the History tab. Can you paste the query out here so that we can figure out where the error is?

[Ritesh]

The error means that no MySQL server is running on the server specified. As you have given localhost that means that you would like to connect to a local MySQL server i.e. one installed in your machine.

• Make sure you have installed MySQL correctly. You can download MySQL from http://www.mysql.com
• Start the server. Read the MySQL manual on how to startup the MySQL server
• Give correct UserName/Password in the SQLyog Connection Field dialog.

HTH

[Ritesh]

Check out Whats New Page of SQLyog. This was a bug which has been fixed in SQLyog 3.1 onwards

HTH

[Ritesh]

Quote:

select * from `gentradedbprod`.`symbolticksummary` order by tickcount desc limit 0,5000;

select * from `gentradedbprod`.`mysqlticks` order by tickID Desc limit 0,5000

update gentradedbprod.symbolticksummary set ticksperday = tickcount/daycount

select * from ticksummary where symbolID = 3213 and BarDate=73895  GROUP BY SymbolID ,BarDate ORDER BY symbolID, BarDate;

The above queries are taken from the SQL file provided by you. There is no ; before the Update statement . You need to put a ; after the select * from `gentrde… query.

Without the ; SQLyog is not able to figure where the query ends 😀

The correct SQL stmts are given below –

Quote:

select * from `gentradedbprod`.`symbolticksummary` order by tickcount desc limit 0,5000;

select * from `gentradedbprod`.`mysqlticks` order by tickID Desc limit 0,5000;

update gentradedbprod.symbolticksummary set ticksperday = tickcount/daycount;

select * from ticksummary where symbolID = 3213 and BarDate=73895  GROUP BY SymbolID ,BarDate ORDER BY symbolID, BarDate;

;

HTH

[Ritesh]

Which version of SQLyog are you using?

BTW, Insert/Updare screen starts with F11 ???? F8 is Execute For Update…

[Ritesh]

Which DB you were importing into MySQL.

Neway, we will work on it 😀

[Ritesh]

Thanks for the suggestion 😀

[Ritesh]

Looks like you will be connecting using dial-up internet account. If thats the case then ask your host to give you % in the Host field of MySQL User table. That will allow you to connect from any host and not one particular host.

HTH

[Ritesh]

Quote:

Is there a way to “synchronize” database data?

Read the MySQL Doc on Replication

Synchronizing data is in the TO-DO list of SQLyog Max 😀

Quote:

BTW, how hard would it be to add code to prevent double submitting on my site (like you have done below)

Can you be more elaborate?

[Ritesh]

BACKUP DATABASE… uses the MySQL's Backup Table SQL and will only take backup if the MySQL and SQLyog are installed in the same machine. It cannot take remote backups.

The best way to take backup's of a remote server is by using DB->Export Database As Batch Script…

HTH

[Ritesh]

Quote:

That's it…

😮 :eek::eek:

[Ritesh]

Hello

We have downloaded the .sql script and working on it. But its very difficult to test it since we dont have the correct database structure.

Can you send us a .sql script for recreating the database at our testing machine.

Waiting for your response and looking forward to sort the problem out 😀

[Ritesh]

Great ideas make great tool 😀

[Author]

Posts