Hi, according to http://help.directadmin.com/item.php?id=193 I used the script to change a username (CentOS, 64-bit). However, during the change the database under the user got completely trashed. The name got changed, but most tables were missing, permissions were also not setup correctly.
A few errors popped by whilst running the script, but execution continued:
I've used this scripts quite a few times before, and the only major thing that is different is that this database had a few MySQL views in it. These have caused import/export problems for us before (the famous CREATE ALGORITHM ... missing DEFINER stuff). It seems that the import failed, and that the script merrily continued deleting the existing database.
Luckily I had a good backup, but it gave us a bit of a scare
A few errors popped by whilst running the script, but execution continued:
Code:
PHP Warning: preg_replace(): Delimiter must not be alphanumeric or backslash in /usr/local/directadmin/scripts/change_database_username.php on line 46
PHP Notice: Undefined variable: newuser in /usr/local/directadmin/scripts/change_database_username.php on line 49
PHP Warning: preg_replace(): No ending delimiter '_' found in /usr/local/directadmin/scripts/change_database_username.php on line 78
PHP Warning: preg_replace(): Delimiter must not be alphanumeric or backslash in /usr/local/directadmin/scripts/change_database_username.php on line 81
PHP Warning: preg_replace(): No ending delimiter '_' found in /usr/local/directadmin/scripts/change_database_username.php on line 84I've used this scripts quite a few times before, and the only major thing that is different is that this database had a few MySQL views in it. These have caused import/export problems for us before (the famous CREATE ALGORITHM ... missing DEFINER stuff). It seems that the import failed, and that the script merrily continued deleting the existing database.
Luckily I had a good backup, but it gave us a bit of a scare
