MySQL Administrator GUI Disappear When Restore Backup On CentOS 5.x
Aug 5, 2008
I 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?
View 4 Replies
ADVERTISEMENT
Sep 24, 2009
I 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.
View 8 Replies
View Related
May 10, 2008
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.
View 0 Replies
View Related
Mar 20, 2014
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...
View 7 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Feb 11, 2008
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?
View 2 Replies
View Related
May 3, 2008
Backing up a server is obviously very important. Lets say I do a daily rSync backup and eventually my server HDD crashes, I know it isn't just a 'one click' job to restore my backup but what is it necessary to do in order to carry out a complete and effective restore back to how it was?
A step-by-step 'tutorial' on restoring an rSync backup would be helpful not just to me but to many 'would-be' server administrators.
View 4 Replies
View Related
Jan 4, 2009
The only backup I could get from crissic was my hypervm backup...
Can anyone tell me if it's possible to just restore this backup on a new VPS and have the code and mysql back to life? At the moment i've looked into the backup and can see the html files and the mysql database files.
View 7 Replies
View Related
Nov 11, 2008
How can create backup fron an openvz vps and resote on another openvz based server?
View 3 Replies
View Related
May 1, 2009
i have install nttack on my windows server.
i want to creat backup from my server (nttack and ... )
that i can restore it on my other vps.
i want to trasnfering.
and so creat backup and then restore is good for trasnfering and on certain vps good for securety.
how can i do it? i mean creat and restor.
View 3 Replies
View Related
Aug 10, 2007
My VPS server was hacked.
Hosting can not find a valid backup to restore.
I have a rsync backup of /home including all accounts.
Now, I thinking the best way to start recovering.
The VPS will be a fresh setup...
View 8 Replies
View Related
Jun 20, 2007
i have a cpanel server. due to some problems , one of my customers asks me to terminate his account and create it again WITH NEW DOMAIN NAME and restore old backup in this new account. how can i restore old backup in this new account that they have different domain names and usernames!
View 5 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jul 8, 2009
I have inherited a server that has somewhat non-standard config, e.g. NFS mount and lighthttpd. I don't have a handle on all the way it is setup quite yet.
So my question is: If I rsync backup the hard disk to an offsite backup, then in case of a crash, can I restore the whole thing (again using rsync) without any tweaking necessary (which I may not be able to do). In other words, would the webserver start working without any tweaks?
View 9 Replies
View Related
Jan 1, 2008
I've virtual dedicated server with goDaddy and i need to upgrade the server Operating system from Fedora Core 4 to Fedore Core 6 and for which i need to backup my site. I am usually doing like this.
1. make a tar ball of all the files and ftp to my local Fedora core 7 desktop
2. Running MySQL administrator from my local Fedora core 7 desktop and connecting to my site database server and finally saving the .sql file.
Now i need to go for upgrading operating system on the hosted server and i would like to make sure whether i'm doing the right way for backing up my server. Will i be able to restore back my site?
View 3 Replies
View Related
Jul 14, 2008
how i can restore backup after reload system
this is my partition
Filesystem 1M-blocks Used Available Use% Mounted on
/dev/sda6 1984 254 1628 14% /
/dev/sda8 172669 6405 157353 4% /home
/dev/sda3 24217 2005 20962 9% /usr
/dev/sda2 29057 307 27250 2% /var
/dev/sda1 99 16 78 17% /boot
/dev/sda7 996 39 906 5% /tmp
tmpfs 490 0 490 0% /dev/shm
/dev/sdb1 99 14 81 15% /root/old
/dev/sdb2 20158 17498 1637 92% /root/old/home
/dev/sdb6 2016 37 1877 2% /root/old/tmp
/dev/sdb8 156330 137402 10988 93% /root/old/home-latest
View 2 Replies
View Related
May 27, 2008
I just found out the other day that all my website files have disappeared.
I emailed Servage who said it was a hardware failure.
I don't have a backup as they never advised me to.
They have said they have their own backup but they will NOT use it as it would restore over other people's accounts.
Why can't they just restore it to a different server and copy?
I am fighting them on this, they didn't even tell me there had been a failure.
View 14 Replies
View Related
Apr 12, 2008
Would anyone happen to know the commands to restore a master backup file via command line on a hypervm master node?
View 2 Replies
View Related
Jun 10, 2007
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?
View 5 Replies
View Related
Sep 17, 2007
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
View 3 Replies
View Related
Nov 3, 2008
How to make backup of VE's(created with openvz) to .tar.gz and restore later?
View 4 Replies
View Related
Jan 11, 2008
I use Incremental backup feature of Cpanel but seems it does not work properly.
Yesterday when i restored my customer account, it brought back the files and database of 2 months ago. I set it backup everday so why this happen?
My server run Centos 4.5 and Cpanel Stable
View 2 Replies
View Related
Nov 18, 2008
when i want to Restore full backup see this error
Restore for cpmove-wwwpakh.tar.gz
Searching /home....
checked 25 files.....
No Restorable archives found!
Searching /usr/home....
checked 0 files.....
No Restorable archives found!
Searching /web....
checked 0 files.....
No Restorable archives found!
Searching /home2....
checked 0 files.....
No Restorable archives found!
Searching /home3....
checked 0 files.....
No Restorable archives found!
Searching /root....
checked 12 files.....
No Restorable archives found!
Searching /usr....
checked 16 files.....
No Restorable archives found!
No archives where found for user wwwpakh.tar.gz!
This feature will restore full backups, cpanel backups and cpanel move files in the format of:
cpmove-user.tar.gz, user.tar.gz, backup-date_time_user.tar.gz
The files must be in one of these directories on the server:
/home,/usr/home,/web,/home2,/home3,/root,/usr
You must upload the file to one of the above locations before using this feature.
why i see this error ?
View 6 Replies
View Related
May 24, 2014
I recently opened a new plesk account on another server and need to restore a backup from a previous server. Both plesk 11.5.
How can I do this ?
I don't have ssh or other access.
Can I just copy the guid ID off the new server and overwrite the extracted backup files?
Only issue I have with that is that a can't redo the XML file required for uploading backups to restore...
View 4 Replies
View Related
