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

Restoring Mysql Db From .frm, .MYD, .MYI Files

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

Getting Error While Restoring Database.

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

Restoring MySQL Database From Raw Files

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

Password Mismatch Error On Restoring Db Via Ssh

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

Error When Restoring Reseller Privs

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

Plesk 11.x / Windows :: Out Of Memory Error When Restoring Database From Repository

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

Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql

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

MySQL Error : MySQL Server Has Gone Away

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

Mysql Account Access

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

MySQL Account Maintenance

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

WHMCS Error While Creating Account

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

Upload Error After Account Moving

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

How To Find Out Which Account Is Making The Biggest Load On Mysql

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

Forbidden 403 Error Godaddy Hosted Account

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







Copyrights 2005-15 www.BigResource.com, All rights reserved