hello.
I want change my mysql database from version 4 to 5.
I have made a copy of the old database in mysql 5 and now I don't know what I exactly have to do.
How can I connect the new database with Gossamer Links?

btw: my provider changed host from localhost to localhost:/tmp/mysql5.sock
is that a problem? My hoster is 1&1.

Hi,

Mmm... I don't think your host will change the "mysql host" for accessing it? (looks like a VERY weird host if thats what they've told you to use!)

As far as I'm aware, if they have changed the server to use mySQL 5 instead of 4, then you shouldn't need to do anything.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

hi.

I wrote my mysql data in the database.def
after clicking (in ....admin.cgi?do=page;page=setup_sql.html)
i got an error. he couldn't connect.
whas that the right way?
i have only acces to mysql5 with localhost:/tmp/mysql5.sock.

Hi,

I've *never* seen mySQL accessed like that. You either use "localhost" OR 123.123.123.123 (i.e the IP address of the mySQL server). I would contact your host and ask them what they are on about

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

they say her configuration is ok... :-(

http://faq.1and1.com/dedicated_servers/managed_server/10.html

is it possible to backup the old db (mysql4) via shell?
than I would not change the old mysql4 db and make my backups via shell.
on mysql4 i have "localhost".

my reason for the db change: 1&1 is changing php to 5.4 and that does not accept mysql 4 db. And now im looking for a way to make backups. in the past i did it with a php script (mysql-bumper)...

Hi,

You can back it up from shell using:

mysqldump --add-drop-table -uUSER -pPASS -hlocalhost DB_NAME > backup.sql

That will back it up in whatever format - but I'm not really even sure what you mean by "version 4" ? Cos 4 and 5 still works the same - export in version 4, and it should import just fine into version 5.

Afraid I can't really be much more help than that.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

i'm looking for a way to make GL backups in the future. at the moment i have php 5.2 and can make backups. but in the futur i have only php 5.4 and that does nocht accept mysql 4. so i thought: export GL to a mysql 5 db and i have no problems in the future. export from 4 to 5 was no problem but now i can not connect the new mysql 5 db...

Mmm it may be better to email support [@] gt.net about this, to see if they can help you out.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

ok. thx. i will try it...

There isn't an explicit option to set the socket filename, but to get around this, you can set your hostname option to be:


Adrian