[nicmar]

Like i said in the last post, i got it to work second time i tried sja.

That was from localhost (direct) -> Mysql 4.0 (Tunnel)

Now I try localhost (direct) -> Mysql 4.1 (Tunnel) with the same custom application, which means that the table structure is the same as in the above transfer.

There might be some conflict with the building of tag files, i will now try again.

Nope same error, here's the error log:

---

Sync started at Thu Mar 30 11:55:16 2006

Error No. 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 'DEFAULT CHARSET=latin1' at line 5

Error No. 1146

Table db_name.table_name' doesn't exist

Error No. 1064

---

On and on for each table.

I guess this is the same problem as in phpmyadmin when trying to export 4.1 table, import into 4.0. In phpmyadmin you can set “use mysql4.0 compatibility”, and it doesnt type the “default charset..” and the ENGINE=MyISAM is changed to TYPE=MyISAM.

Is it possible to add this to sqlyog, or even better, detect what databas version it is on both servers, and use the correct syntax?

So what I'm left to do is enter the phpmyadmin on the 4.1 host and do a 4.0-export there. It kind of sucks 🙁

-nicmar

[nicmar]

I still have problems syncing databases, and as usual when it's a rush..

First i tried the SJA, and it didnt get very far, just stopped on something like “an error has occured”, and yet i told it not to stop on errors…?

Second try:

Then I exported all to SQL-file, worked fine.

When i execute SQL-statements from a file, it runs for 1500/4900kb, then says this error:

I x out everything but the structure, and a swedish “ä” somewhere in the data.

Query:

insert into `boka_anstallda` values

('7030','17','','xxxx','xxxxx','xxxxx','[email protected]','','xxxxxxx','xxxxxxx','xäxxx','','','','xxxxxx','xxxxxxx','1','0','0','1143704527','0','','0','0','','','1')

DROP TABLE IF EXISTS `boka_badlogin`

Error occured at:2006-03-30 10:52:07

Line no.:13936

Error Code: 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 'DROP TABLE IF EXISTS `boka_badlogin`' at line 3

So my third try is to use the SJA again:

Well.. now it worked, thank god 🙂

It feels kinda dangerous to be using a BETA-version on a Live important database, is there any risk of data loss?

It's always easy to transport small databases, but the kind at 5Mb, which not really is HUGE, always feels more risky.

-niclas

[nicmar]

Yes, the problem was that i dismounted the encrypted drive while mysql was running, so it freaked out. But it all works now.

I have a bat file on startup:

“mount truecrypt disk” (actually the real parameters;)

net start mysql

net start apache2

This way it wont try to start mysql/apache2 until after the disk is mounted.. Works like a charm!

I got a problem though, I moved SQLYog from C:program to e:program (encrypted disk), but all the favorities got lost. Where are they?

When I moved it back to C: they are still gone.

I checked this path but it's empty:

C:Documents and SettingsNiclasApplication DataSQLyogFavoritesPersonal

Is it some kind of security function or something, or are my favorites still on the disk somewhere?

I wanna store the favorites on E:, the encrypted disk, not Documents and settings. All files in that folder are impossible to protect, as far as I know.

Any clue on this Peter?

[nicmar]

Interesting..

I created a virtual encrypted file as E: and placed the data in E:mysqldata , i simply copied it. When i connect to the DB using Sqlyog I can see all tables, but there are no tables in it..

When I try to connect using a php script it says DB Selection error : Unknown database 'dbname'

I'm not sure if I corrupted anything cause I tried to demount the virtual file while mysql was still running.. I'll reboot and see what happens..

By your descriptions paragon sounds to work just like truecrypt..

brb

EDIT: Sorry never got time to test it, i'll try again tomorrow, Do you know if i have to do anything special more than to move the files in mysqldata to a new folder and change my.ini?

[nicmar]

Ok, TrueCrypt is 100% free and open-source, I will try that now.

Another concern I have is Internet explorer and stored passwords in cookies. It's useful, but is it possible to store these on an encruypted drive? I think that you cant encrypt the SYSTEM (C:) drive?

How about your paragon software?

[nicmar]

Ritesh wrote on Mar 28 2006, 05:47 AM:

Can you post the table sturcture of the concerned tables?

Was building of tags for autocomplete going on when you left your PC?

How long you think were off from the computer?

Sorry, dont know what table it was.

Building of tags was finished.

I was away more than 20 minutes I think.

Possibly the network connection got disconnected meanwhile (unstable WLAN on a laptop)

[nicmar]

Shall I still try it? Where is the Beta 4 download? I forgot.. 😕

[nicmar]

I'll mail you a dump of the entire db, ritesh.

It's not confidential, but don't post anything on the forums thanks, there are some personal details, but mostly test data.

Btw, i'm using PHP 4.4.1 and Mysql 4.0.26 both on my localhost and my ISP .

I've sent the file to ritesh via mail.

[nicmar]

Ok, somehow i never got that error this time, but I got it before, and reported it as a bug somewhere else I think.

I hope ritesh can fix it!

I'll have to try to live through my day until then.. 🙂

thanks for your time!

[nicmar]

The file sja.log wasn't created. I guess it's created the first time you connect to a server, but that I couldn't do.

No the tag-files didn't hang the system. The first time i used it and connected normally (not http) it just hang, with no message on screen.

When I then reconnected and used http, the tag-files was built.

I still have no sja.log though.

I now connect to my ISP through the BETA (i didnt try this before) and the building of the tag-files is pretty slow and making the program act hung, but it worked out.

I tried to do the database-copy now with the BETA, and I got exactly the same results, the table is empty.

There are some tables in the ISP-database that has nothing to do with the localhost, but that shouldnt matter, should it?

[nicmar]

I got the same problem, but somehow the reverse.

Always when i start sqlyog, it's the “max size” of screen, NOT maximized. This means that when I want to close the program, I move the mouse to the upper right of the screen and click.

And to my surprise (every time!) the maximized program behind sqlyog gets closed, and I get really annoyed.

Of course, this only happens when I forget to maximize SQLyog on start, but it's mostly on short in-and-out sessions.

A preference on how to start it would be good.

Wait. I'm being stupid here. I just realized i can right-click the shortcut of the program and set it to open maximized. Yeah, it worked. Hehe.. Sorry to bother you, but I hope this helps someone with the same problem as me 🙂

[nicmar]

Yep, no data coming through. I do like this:

1. Right click the database and choose “Copy database to different host/db” (So i'm not using the structure synchronisation tool)

2. I make sure “Drop table if exists in target”

3. Select Structure and data

4. Press copy

No error messages, nothing in the log. It proceeds to the other tables. And there is no “exit on error”-option.

If i do it manually, this is the data from localhost:

[edited]

There are no quotes around the first field, which is the primary key.

Does this make it easier to find the problem? 🙂

[nicmar]

I will read that file, but it was pretty long 🙂

Where is the log? I searched in the program dir but didn't find anything.

Now i tried to connect with the http tunnel on my localhost, and the program worked. And when i disconnected and connected without tunnel, it also worked.

Although the first time i connected succesfully (with tunnel) it started to build a lot of tag-files. If that has got anything to do with this.

My localhost server had username root with no password, but that shouldnt be a problem either?

So somehow the problem is worked out. Don't know if this helps you in any way? 🙂

[Author]

Posts