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
How do I change mass database names in mysql?
I have hundred of database names with "$" in the name? How do I change all instances of "$" with "_"?
any hosts that can provide the following:
PHP5.3 +
MySQL
CRON (to run daily/weekly scripts at a certain time)
Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly.
In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
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
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.
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 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?
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...
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 have a VPS and about 140 accounts on it. I'm moving to a new host, but the thought of having to move all these accounts manually really makes me lazy I have to go into each account and go to backup -> backup to remote FTP.
Is there any way I can mass backup all of my accounts, or all accounts I select, to a specified FTP server?
Running freebsd with pf, and was wondering if there's anything like www.fixingtheweb.info for pf instead of IP tables? Otherwise it'll be a long day
View 1 Replies View RelatedI have client who wants to send out a few hundred thousand emails once every week. They are into educational stuff and have these many subscribers.
I was wondering if there is any hosting available for this kind of mailing. I have the script buts its just my current host has limited mailing to 50 mails per shot and maximum 500/hour
I would have gone for dedicated or vps but I am completely ignorant about it.
Is there a way out for me?
i need any thing to prevent mass download
my server is cost a huge bandwidht monthly . because mass downloading?
I'm trying to send a mass mailing to around 50.000 people, as of now, about 70% returns in the exim mail queue with the following header at the top.
Code:
mailnull 47 12
<bounce@domain.com>
1244115246 0
-helo_name www.example.com
-host_address 222.21.147.57.38441 (fake)
-host_auth fixed_login
-interface_address 222.21.147.57.25 (fake)
-received_protocol esmtpa
-body_linecount 219
-max_received_linelength 108
-auth_id info@domain.com
-deliver_firsttime
-host_lookup_failed
XX
1
The problem is in the host_lookup_failed part.
If you know you can help, please let me know, and I'll send you the real ip addresses and domains, I don't want this to show up publicy.
Every month or two, we like to send our members a newsletter-type email which just informs them about what's happening over in our website and community. We have over 350,000 accounts registered, so there's quite a few emails to be sent each time.
I'm currently using cPanel with Exim and SwiftMailer to send the members an email through PHP. The way I do it currently is import all the email addresses to a separate table then email 500-1000 at a time. This is controlled by a Cron job.
I'm finding Exim to be extremely slow and the queue has built up to 190,000 as I type this (the email process started last week).
My question is this. What's the best software, whether it be a program or a script of some form, to send an email to such amount of users? Or if anyone knows any way to 'tweak' Exim to handle such mass-emails.
What command do I use to mass extract a bunch of .tar files? I have a directory with about 60+ .tar files that I want to extract at the same time instead of doing it one by one.
View 4 Replies View RelatedI'm hosting with CoreNetworks (very happy with them) on a Windows platform. One of my clients has a 500-person email list. When they try to send using Outlook, the get the following error:Sending and Receiving' reported error (0x800CCC0F) : 'The connection to the server was interrupted. If this problem continues, contact your server administrator or Internet service provider (ISP). The server responded:? 1 Too many bad commands, closing transmission channel'
They didn't have any problems with sending from the list before, when I was in a shared platform with AIT. Ideas as to what the issue could be? I've done some research but can't seem to figure it out.
to rename about 1100 files from SSH. The filenames contain (, ), and spaces, and I'd like to eliminate all of those characters. Can this be done with a simple command?
View 0 Replies View Relatedbuilding a mass storage server, but unsure whether it is better to go for most space per system, or most space per U.
Looking at making 2 storage servers sometime in the future, one more for performance (15k 300gb SAS drives) and another for more storage (bunch of 1TB SATA drives). Both would act as iSCSI targets and likely have multiple gigabit ethernet connections bonded together.
Some options I am looking at:
1) HP DL320s provides 12 drives in 2U, or 6 drives per U. Upgrade it to 512mb batter backed cache and it does RAID6. Probably the densest storage U.
2) Supermicro has a 3U chassis that does 16 drives, or 5 1/3 drives per U. Pair that with one of the newer Areca SAS controllers and up to 2gb onboard cache and it should scream.
3) Supermicro also has a 3U chassis with 15 drives... just 5 drives per U, though it is ~$200 cheaper than the 16 bay one. Probably a mute point, since either way, it is less storage per server and less storage per U.
4) Get a simple 1-2U case and use external JBOD enclosures. Could put in multiple RAID cards, hook it up to multiple 3U 16 bay enclosures, and really squeeze in a lot of storage per server.
Anyone else been in a similar boat? Overall, not looking for a real dense configuration, with like 10-20 servers of this config, so don't *need* to squeeze in more TB per U, but it is one way that I've been looking at it.
Perhaps, in a way torn between the pre-built DL320s and the white label Supermicro approach. DL320s is a nice packaged system, support, iLO, etc. Supermicro allows more space and likely more performance (Areca likely better than the HP SmartArray), but no iLO, no single source for support, etc.
I'm currently owning a website with little less than 500,000 users. Many of these users have been asking if I could send out updates about the site per email, like once per week or preferably once per day.
I'm not sure about the best way to do this. I did some reading and some people seem to suggest to get an extra dedicated server to send out the emails. Others say it's best to use a cloud service with SMTP relay, while I also saw suggestions to use a website like [url]
I have checked into mailchimp, and appearantly this whole thing will be very expensive if I want to send out email to so many users. I'm not an email marketeer and neither do I sell products, so the profit per user I would email is probably low. The primairy reason I want to send out updates is to keep my current memberbase happy, and to get some older inactive members to become active again. We had our site totally reworked recently, and it would be nice to let people know about that.
I also like to know if it's possible, in any service, to somehow unsubscribe users whos email addresses are no longer valid in an efficient way.
Some more facts:
- Those 500k users are 250k effective emails. The other people have never subscribed on registration, are blocked for misbehaviour on the site, or have unsubscribed at some point.
- As stated above, people have to subscribe upon registration. The checkbox for this is unchecked on default
- The oldest users in my database are 3 years old, so there is quite a chance emails might be no longer active.
- There are many scams in the industry I'm active in (survey panel). As a result, users are sceptical, and sometimes use alternate email addresses for registration. I believe that as a result of this there is a higher chance the email is nog longer in use than on other sites, although I have no stats of other websites to compare with.
- I once tried to send out email to 75k users on my current dedicated server. As a result, Yahoo deferred my emails (which caused trouble for the verification emails we send out upon registration). I contacted Yahoo and they whitelisted my server, but I don't feel like trying to send email from my current dedicated server again. Not to mention that the server had a lot of trouble sending out so many emails, the server load was really high while sending out all email.
One of our servers was incorrectly set up before migration occurred. Now the ns records are incorrect on many domains' zone files. Does anyone have or want to let me hire you to write a script to change all the ns records and that are currently ns1.something to dns1.something. It can't be for every domain on the server, just the ones pointing to the incorrect ns, as some of them are correct. Linux server.
View 7 Replies View RelatedI've not seen an answer for this mass 301 redirect issue specifically.. How to do this...
category/brand URLs:
redirect: /ID-some-brand (e.g. /43-religion-clothing or /26-ichiban) to: /some-brand (e.g. /religion-clothing or /ichiban)
Product URLs:
redirect: /some-category/ID-some-product-name.html (e.g. /mens-sweat-shirts/1543-ichiban-fairly-offensive-sweat-in-grey.html)
to: /some-product-name (e.g. /ichiban-fairly-offensive-sweat-in-grey)
We have 1,090 products and 60+ categories so some form of .htaccess trick would be amazing to know. What I could put in the .htaccess to accomplish this.
it's in my clients contract that they must use our email marketing software to send out mass emails.
we are running WHM with the clients website on a cpanel account.
is there a way for me to monitor the email traffic so i know if they send out emails to more than 50+ recipients at a time?
im aware that they are sending emails through their desktops using normal smtp accounts, so need a way to prevent this if it's possible.