Creating Db On Host Site With Phpadmin

[JimS]

To create tables for an app on my hosting site I create a SQLyog database dump and then import that into phpMyAdmin. This works if I delete the comments out of the dump first otherwise it creates errors in phpMyAdmin. Is there a way to not have the comments put into the dump? If not is there another way to approach this after I have created my db localy and wish to move it to production?

[peterlaursen]

I think the issue is that you have a local MySQL server version 4.1 and higher, and the hosted server is 3.23 or 4.0. The latter versions do not support comments.

We have a similar request to have an option to provide 'fully 4.0 compatible backups' from higher version. There is no such option currently.

If you connct to both servers at the same time you can use 'copy to other' or 'data sync' – they will work across versions. But if you cannot connect to the remote host with direct connection, you will need HTTP-tunnelling or SSH-tunnelling – what is only supported with ENTERPRISE.

Give the ENTERPRISE TRIAL a try? For a setup with a test/development server and a production server the STRUCTURE and DATA sync tools of SQLyog ENTERPRISE will save you lot of time.

[JimS]

peterlaursen wrote on Oct 23 2007, 06:16 AM:

I think the issue is that you have a local MySQL server version 4.1 and higher, and the hosted server is 3.23 or 4.0. The latter versions do not support comments.

We have a similar request to have an option to provide 'fully 4.0 compatible backups' from higher version. There is no such option currently.

If you connct to both servers at the same time you can use 'copy to other' or 'data sync' – they will work across versions. But if you cannot connect to the remote host with direct connection, you will need HTTP-tunnelling or SSH-tunnelling – what is only supported with ENTERPRISE.

Give the ENTERPRISE TRIAL a try? For a setup with a test/development server and a production server the STRUCTURE and DATA sync tools of SQLyog ENTERPRISE will save you lot of time.

I have the Enterprise version but I do reseller hosting on Windows servers which I think means I can not do HTTP-tunnelling or SSH-tunnelling or can I?

[peterlaursen]

On windows servers to use tunnelling the requirements are

HTTP tunnel:

***********

PHP (>= 4.3.x) must be installed and mysql or mysqli extensions must be enabled. If you use IIS 6 with Windows there is a known issue with the php-distribution with automatic installer (a problem with url_encode in the HTTP header – please tell if this is the situation – we can provide a special build to solve this). The PHP package for manual configuration has no such issue. Also no such issue if you use Apache with Windows (any Windows version)

SSH-tunnel:

***********

Windows does not support SSH natively. You must install a SSH package. OpenSSH for windows works fine. Download link: http://sshwindows.sourceforge.net/download/ . ON Win2003 a few tricks are required to configure it – a good configuration guide is http://www.cs.bham.ac.uk/~smp/projects/ssh-windows/ . On 2K and XP just follow the 'quickstart' guide in the Openssh folder. OpenSSH installs a Cygwin instance (and not the latest one – the package available is now three years old) and you can only run one Cygwin. If you are capable of UNIX systems from command line you can of course also install Cygwin yourself and build OpenSSH on it! 🙂 Normally this is not required, but may be necessary if you have more unix/linux softwares on your Windows box that need to use Cygwin.

[Author]

Posts