Error With Mysql While Restoring Account
Aug 12, 2008
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases:
Quote:
ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database roundcube......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists'
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database horde......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists'
ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist
ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist
ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist
ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist
ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist
ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist
ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string
Done
What does this error mean and how to solve this problem?
I have updated cpanel and mysql but the problem is still found
This problem found while trying to restore any account not this one only..
View 1 Replies
ADVERTISEMENT
Jun 21, 2007
I did the absolutely most stupid thing yesterday, I emptied the wrong mysql table via phpmyadmin. Fortunately my host managed to grab a the table in question from a few days ago.
So I have:
auctions.frm, auctions.MYD, and auctions.MYI
My assumption, is that I can just overwrite the current files of the same name in the mysql folder, and everyone will be happy. Is there some more to this process?
View 8 Replies
View Related
Feb 5, 2008
SQL query:
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
UNLOCK TABLES;
--
-- Table structure for table `qhvbmailer_campaigns`
--
DRO' at line 1
View 8 Replies
View Related
Apr 9, 2007
Is there a way to restore a MySQL database from the files located in /var/lib/mysql?
Unfortunately I don't have a mysqldump of the databases, just the raw files from an image of the server.
View 3 Replies
View Related
Apr 7, 2009
Trying to restore db for my friend, was able to back up db via ssh using the username and pwd, but while restoring db in a new host get : Password mismatch error,
View 0 Replies
View Related
Jul 30, 2007
i try to restore a backup from another hosting to my server and always get stucked on "restoring reseller privs"
i'm using restorepkg username and got this error
Code:
not a reference at /usr/local/cpanel/Cpanel/CachedDataStore.pm line 27
at whm i can transfer multiple account and select "skip restoring reseller privs" but in this case my old hosting doesnt provide ssh access.
i was wondering is there any paramater to skip that?
something like
Code:
/scripts/restorepkg -somethingblahblah accusername
View 0 Replies
View Related
Jun 13, 2014
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info:
Plesk 11.5
Windows 2008 R2 (64Bit)
3GB RAM
MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
View 1 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Mar 24, 2009
I run a shared hosting
OS:centos with whm/cpanel
and would like to restrict access to mysql database
example:
username:user1 created database:user1_db1,user1_db2 etc..
and can only access his own databases
so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View 4 Replies
View Related
Jan 25, 2007
I have 150 accounts on my server and suddenly 75 accounts the users of the Database are deleted?
you can see this account:
[url]
View 2 Replies
View Related
Oct 27, 2009
We are using WHMCS with Plesk 9.2 which was working all perfect but from last few days when ever we click on "CREATE" hosting account module in WHMCS it gives us the following message.
Module Command Error
CURL Error: 28 - Operation timed out after 100 seconds with 0 bytes received
we tried to contact WHMCS support and they says its related to Plesk and parallels say its related to WHMCS now i am stuck between these 2 companies!
View 9 Replies
View Related
Jul 23, 2008
I have just moved hosting script account from one server to another server and now when I try uploading an image, I am getting the following error
Warning: move_uploaded_file(./uploads/8e90ced776.jpg) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/imgrip/public_html/upload.php on line 29
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpDmsMkq' to './uploads/8e90ced776.jpg' in /home/imgrip/public_html/upload.php on line 29
Anyone would be kind enough to let us know how to fix the error?
View 8 Replies
View Related
Apr 26, 2008
My Server Is down nearly every day in the last three days
I think one of my clients is sending emails from his forum to his members.
How can I know who is he, And most important can I stop him from emailing his members?
Also,
How can I find out which account is making the biggest load on MySQL?
View 4 Replies
View Related
Jan 26, 2009
I recently uploaded files to my hosting company and when I try to access site through browser I recieve 403 Forbidden error you dont have permission to access / on this server. They say it or the problem lies in the index.html file in which I know very little about. Any help would be greatly appreciated.
Heres is the source code HOSTED @ GODADDY APACHE LINUX .....
View 4 Replies
View Related