[PerFredlund]

I also tried to do backup with MySQL administrator. The query browser cannot do this (why they recommended that? Hmmm …) This time i got the following error message:

“An Error occured while executing the backup. MySQL error.”

Hmmm. I do not feel like paying for their “professional service” and letting them do the backups …

Per

[PerFredlund]

Hi 🙂

Bad news. I troed again to do backups. After their proclaimed maintenance frame was over. Still same problem. I tried to do a copy of the db. This time sqlYog crashed on me. I will include the dump file (I had to rename it). I am getting thoroughly frustrated with this 🙁 And yes i disabled transaction support as suggested. Any help is warmly welcome. The site support actually recommended me to use the MySql query browser for doing backups 🙁 I will try that also …

Per

PS! Im doing normal backup, not scheduled. I believe scheduled backups is only available in the pay version ??

[PerFredlund]

Hi 🙂

I tried to remove the bulk insert option – but still same problem.

I will investigate a bit more and report it to the webhost helpdesk if i cannot sort it out.

Per

***update***

I contacted support. They say they are doing mySql maintenance at the moment. However they made a backup for me. So that's ok for now!!

Per

[PerFredlund]

George wrote on Jul 29 2008, 08:04 AM:

yeah.

Well, i guess i will have to be content with %.% in the end. Still seems weird that mysql doesnt resolve the hostname…

Many thanks

As i have understood it it's not really up to mysql itself (directly) to allow remote connection. That is a feature of the web hotel (web host). Most control panels have own settings for remote access (possibly in mysql).

I have successfully used the wildcard ip-specification to allow a range. Sometimes this range is dropped after a number of failed log in attempts. Or after doing other changes – in which case you can add the range again (annoying).

– Per

[PerFredlund]

Hi 🙂

It is possible to write a stored procedure for such purpose. But that is not pure sql anyway. It's an extension, and various databases have implemented stored procedures in slightly different ways. Stored procedures are useful when you have to deal with complicated tasks over many databases. Or simply when you have to process a result set with various conditions (traversal).

– Per

[PerFredlund]

So …

Why it's like that also for my wife?? 😀

I'd have believed that you log ip's or something like that 😆

– Per

[PerFredlund]

Hi 🙂

I would like to add a quick comment. I would guess 99.99% coming to this site already know what mysql and query browsing is. So i do not see any big reason to elaborate on this. Should the site also explain what is a relational database is? And its uses?? I think that is far beyond the point of the website anyway. Those who would need Sqlyog or other of their products are supposed to know all those things anyway — IMHO.

It's almost like: don't get a registry cleaner if you have no idea what is the registry in the first place 😎

– Per

[PerFredlund]

TuconsMike wrote on Mar 17 2008, 06:25 PM:

Great. Thanks.

Hi 🙂

This php file is not included in my installation folder, im using community edition version 6.54. Coud this have something to do with me upgrading successively from older versions (ie some installer error). What should be the exact content of a freshly installed instance??

– Per

[PerFredlund]

peterlaursen wrote on Feb 20 2008, 11:03 PM:

w's (like waiting, waltzing and whisky) will strengthen your character! :P;)

Why could not a connection-specific prefix be added automatically, and transparent (invisible) for the user ??

Features vs speed and simplicity is always a trade-off 🙂

– Per

[PerFredlund]

Hi 🙂

Personally i would add 202.71.%%%.%%%

This covers more ip-addresses than you need, but better safe than sorry. Any other people would still need your username and password to be able to connect 🙂

Such a big range worked fine for me …

Good luck,

Per K Fredlund

[PerFredlund]

Hi 🙂

A few comments only. This thread is becoming old 🙂

If your web hotel is using Cpanel as the users control panel then accessing remotely to MySql should always be possible. It is a Cpanel feature. I cannot see why the web hotel would “fix” the Cpanel to disable this (essential) feature.

When adding allowed remote hosts to MySql recall that a wildcard (%) replaces ONE character only.

So specifying range 222.222.50.1 – 222.222.50.255 for instance should be written as 222.222.50.%%% and NOT as 222.222.50.%.

If you are working from a broadband xdsl connection you most likely have dynamic ip address. But always within some range (subnet). You can quite easily find out what range you should set up to avoid adding new ip every day or so. That is too annoying!!

– Per

[PerFredlund]

Hi 🙂

It seems that the other databases behave correctly. I can select an engine during creation, from advanced. So, contradictory to “common sense” the older MySql version behaves more correctly than the newer version. I'd be surprised if my webhost have configured these versions differently. I use the same host (Siteground) for all those sites. Oh well, as i said it's a minor issue – i can always take a second round and update the engines before “going live” 😎

The timeout setting seems to have worked on the mustcube site. The frequent “sql has gone away” messages are much less abundant now.

Thanx for the help 🙂

– Per

[PerFredlund]

Hi 🙂

For the mustcube site this is the following MySql server version: MySQL version 5.0.45-community-log.

For my other (older) sites the version is 4.x.y – cannot recall rite now. I will upgrade these sites to version 5.x.y if the need arises 🙂

– Per

PS! I never said the connection settings and lack of engines available on table creation were related problems 🙂 Why would they??

[PerFredlund]

Hi -)

I thought it was too long to explain how it works in PSPad. If im not careful in sqlyog a new connection will easily overwrite an old connection. Even when choosing new connection (not the using current settings option). And even after haing created several connections sqlyog will only have one connection shown in the left browser pane.

Ok, i attached a snap of the PSPad ftp settings dialog.

I do not have access to advanced server settings on my hosting. Anf if i do i do not know the exact queries to find it out.

As i said i can access advance properties on creation but the engine dropdown list is empty until after initial creation <_< Best wishes, – Per

I just upgraded here at work to latest version, seems i had only upgraded at home 😮 I still see no change with the issues.

[PerFredlund]

PerFredlund wrote on Mar 3 2008, 10:30 AM:

You pretty much just type the server name and then the cpanel username and password most likely. Unless you do indeed have another DB user that you prefer for the connection. I recommend using the ip address as the host address and leave the databases field empty so you can connect to ALL your databases on the MySql server.

– Per

One more thing. Add the remote ip address of your computer to the list of allowed mysql hosts. This is very easy to do with CPanel. After addding a new database you may have to remove and add your ip again to get remote access to also the latest table. I guess this is a CPanel bug 🙁

[Author]

Posts