Hi all,

- I was wondering if i change the field 'URL' (with links->properties in the admin)
from type 'VARCHAR', column size 255 to column size 500 do i lose ALL DATA inside the field ?
- Can i still use the type VARCHAR and does it also change the MYSQL database if i press RESYNC database ?

It's important that i don't lose the data in field url :)

Allready thanks...

I very much doubt that by changing the field type you will destroy any data.

Just in case, type this in SSH (change to your respective database details);

mysqldump --add-drop-table -uSQLUSERNAME -pSQLPASSWORD database_name > backupfile.sql

This should make a backup of your database, just in case something does go wrong (*very* unlikely).

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 Andy,

Thanks for your very quick reply! I will do that.

Cheers.

Could be wrong but I have a feeling that the max length for varchar is 255 so I don't think you'll be able to increase it to 500. You may need to change it to TEXT.