I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error
Quote:
Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.
Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
I take full backup of one site. the site have 250 mb database mysql i click on backup restore inwhm and select site and whm say Restore done. ut mysql can`t restore good
how may i restored the site full?
restore a big mysql database (vbulletin) but the sql backups are all in smaller files, 200+
root@server [/home/user/public_html/db-backup/2007-09-17]# mysql -u user_user -pACTUALPASSWORD user_vbulletin < /home/user/public_html/db-backup/2007-09-17/*.sql
-bash: /home/user/public_html/db-backup/2007-09-17/*.sql: ambiguous redirect
How do I do all in one shot safely?
using mysql 4.1
im currently in the process of movinmg most of my clients MySQL dbs to a dedicated mysql server (direct private lan link so speed/bw is not an issue) but i have ~2900 .sql files i need to restore, anyone got any idea how to automate this restore,
the sql files were created suing mysqldump on old server so have all the appropriate create database entries etc but id rather not have to do each file by hand or ill be here for months
Hard drive failed but I have a backup of the files on antoher drive. I created new database with the same exact name then I copied all files inside /var/lib/mysql/database_name to the new folder. It didn't work, anyone know how to make the database work? I tried repairing it to no avail.
View 2 Replies View RelatedI need to get the h3ll away from Godaddy, fast!
However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot.
Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy.
As to why I need to get away from Godaddy:
Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says:
"Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us."
They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
I have a corrupted VPS, and have some mysql databases on it.
I want to backup databases and restore them on the new server.
Cpanel service is down on the vps and I cannot transfer accts.
Is it possible to do so ?
1- Zip or Tar the username folder in /home dir.
2- zip or tar the database name in /var/lib/mysql folder
Either by SSH or File manager trough HyperVM
Then transfer files some where safe...
When vps is rebuilt, restore the archives and databases to
the folders I have backed up before rebuilt.
There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them.
how to do it and avoid database problems.
i have make a full Plesk Backup on my Old Server with Plesk 12.0(Ubuntu) and will restore the Backup on my new Server with Plesk 12.0(CentOS).When i will restore the backup i get this error: "Error: The source file is not a valid XML file. If you supplied an archive file containing a backup from Plesk version 9 or later, then extract the contents of this archive, and process the extracted XML file with the converter. If you want to convert a backup file from a Plesk version earlier than 9, then you first need to process it with the pre9-backup-convert utility, and then process the resulting file with the pre10-backup-convert utility."
In the Logs i found this:
deployer.log - [URL] ...
import.log - [URL] ...
pmmcli.log - [URL] ...
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies View RelatedI have some server with OS: CentOS 5.x
one day, I have to replicate 2 servers together. so, I have to stop webserver and use MySQL Administrator GUI Tool to backup it. My steps follow: (i work directly on Server 2 and i wantna to use mysql administrator gui to monitor and config replication).
1. Server 2: ssh to server 1-> connect mySQL -> add any host to root access
2. Server 2: use mySQL Administrator connect to server 1 with root
3. Server 2: backup from server 1 on Desktop location
4. Server 2: Restore it use mysql administrator tool.
It works well but when i click Restore button, MySQL Administrator GUI Tool disappear!
What's problem with this tools or server 2?
When restoring a backup on Plesk 12, the error below is generated for some sites and the sites are only partially restored. Although the message talks about disk space, there is in fact plenty of free disk space - i.e. many GB. The backup was created on Plesk 11.5. The restore on Plesk 11.5 works.
I noticed that all the failed domains exceed the disk space allowed by their Service Plan. However, the 'Overuse is allowed' setting is selected. Strangely, I tried changing the Service Plan and retrying the backup and restore, and the same errors were generated.
<object type="domain" name="domain.com">
<object type="hosting" name="domain.com">
<message code="CantUnpackDomainContent" severity="warning" id="f3946c79-7ae2-4be2-8300-ba766bea7869">
<description>Can not deploy content of domain domain.com</description>
[Code] .....
Can't restore.
plesk Internal error: Failed to exec pmm-ras: (array ( 'code' => 127, 'stdout' => 'Transport error: File '_info_1503031904.xml' not found ', 'stderr' => '', )).
in debug mode:
Internal error: Failed to exec pmm-ras: [2015-03-05 16:19:49.215|23284] INFO: pmm-ras started :
/usr/local/psa/admin/bin/pmm-ras --get-dump-info --dump-file-specification=_info_1503031904.xml
--session-path=/var/log/plesk/PMM/logs --debug [2015-03-05 16:19:49.215|23284]
INFO: Repository '/var/lib/psa/dumps': Initializing...
[Code] .....
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?
I cant restore my back up. Get following warnings:
Warning:
php_version 5.3 is not supported. It will be replaced with php_version 5.4 for the following service plans: Unlimited, Admin Simple, Default Domain, Default Simple, Web Presence Builder, SiteBuilder
Warning:
python is not supported. It will be disabled for the following objects: Service plan 'Unlimited', Service plan 'Admin Simple', Service plan 'Default Domain', Service plan 'Default Simple'
Warning:
The component fail2ban is not installed. It will be disabled for the following objects: Server settings
Warning:
php_version 5.3 is not supported. It will be replaced with php_version 5.4 for the following websites: swen.flugzeugbilder.orgClick to expand...
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
When i try to restore a domain from Server Repository I am getting this strange error
Internal server error:
ERROR: Call to a member function write() on a non-object (Apache.php:821)
How could I fix it?
I am getting an Error at running this command '/usr/local/psa/admin/sbin/mchk --with-spam'
boss@server:~# /usr/local/psa/admin/sbin/mchk --with-spam
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
[Code] ....
The Dump Log of /usr/local/psa/admin/logs/panel.log
[URL] .....
Executing: /usr/lib/plesk-9.0/remote_mail_restore/mail_outgoing_restore
Log: [URL] ....
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
View 1 Replies View RelatedI 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
I have this error my site:
dbconn: mysql_connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
*dbconn: mysql_connect: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug*
I recived this error message while testing my website registartions form and was wondering what to do with this and i think it should be permission to access to the database is not given to the user but this is my own account and im the admin and how come the access is denied?
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'alien'@'localhost' (using password: YES) in /home/seektran/public_html/db_connect.php on line 12
Error: Could not connect to database server. Please try again later.Access denied for user 'alien'@'localhost' (using password: YES)
in phpMyadmin when trying to import a database from a file, i'm getting the error:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
The file I'm importing is only 7.08MB
I have tried setting the packet size in the shell as follows:
mysql> mysqld --max_allowed_packet=32M
I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.
MySQL Error : Out of memory
I'm getting this very frequently today
MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :
I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.
I already ran optimization on the database too.
It started happening yesterday, pretty much after I installed this hack:[url]
Quote:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug