Exporting Between MySQL Servers?
Oct 9, 2006
I'm working on transitioning to a new server. Long story short, I have about a database around 100MB in size that I need to get from a MySQL (4.0.25) server to MySQL 4.1.14 server. (Both machines are running Linux and are sitting in data centers with fast pipes.)
What's the easiest way to do this? I have full root access on both machines, ssh access, and phpMyAdmin on both. Is there a way to have one machine read the data directly from the other, say some command line tool? (What I plan to do is to use phpMyAdmin to 'export' it to a backup, download that to my desktop machine, upload it to the new machine, and import it. This seems quite inefficient.)
View 5 Replies
ADVERTISEMENT
Jun 28, 2007
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server...
the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created..
in host i could see server.mysql in php database config files
i want to export database...to linux server
i have not used helm much..
where actually is database located and how can it be exported?
View 4 Replies
View Related
Mar 28, 2008
I was wondering if it is possible to cluster 2 web servers and 2 mysql servers with only one server working as load balancer.
I am planning to use LVS (ldirectord and heartbeat).
Let's say I have 3 IPs allocated to the load balancing server.
111.222.111.222 (Main IP)
111.222.111.223 (Web Load Balancing IP)
111.222.111.224 (MySQL Load Balancing IP)
If a connection is made to .223 it would pass the request to one of the web nodes.
If a connection is made to .224 it would pass the request to one of the MySQL nodes.
Is it possible to do this?
If not, can I run, for example, nginx on 223 IP address to provide forward proxy? (Then it would not be able to HA but the main point is to load balance so)
Also, what would be the best way to keep the data same on both web servers? This is a web cluster for a very high traffic forum with a lot of uploads every hour so it has to do real time synchronization. I heard that DRDB is only one way and not two way so I'm not going to be able to use this.
View 11 Replies
View Related
May 29, 2014
One of my domains has been moved to another hosting company, and now I need to export all emails from the mail account in Plesk in order to import them to the new mail system. I figured the easiest way to IMPORT is to access the new mailbox via Outlook, and import as a .csv file. But I need exporting all the emails from the inbox and sent folder into a .csv file.
I've found the location of the mail box (var/qmail/mailnames/domain.com/user/maildir) but now I'm stuck and don't know how to proceed. Is there an easy way to export all emails?
I've tried through webmail (Roundcube) and there is a "download mail" feature that downloads the message in eml format, but that doesn't work on bulk, only for one mail at a time (and this isn't an option for me since we are talking +1000 emails). Also I'm a bit usure on how to import eml files to outlook (drag'n'drop doesn't work), so a csv option would be perfect.
View 5 Replies
View Related
Mar 29, 2007
we plan to buy one server for apashe and one for mysql.
So first server will handle apache + cpanel + exim
Dual Processor Dual Core Xeon 5140 - 2.33GHz (Woodcrest) - 2 x 4MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
second will handle only mysql
Dual Processor Quad Core Xeon 5345 - 2.33GHz (Clovertown) - 2 x 8MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
Server will be used for forums about 4000, 5000 Simultaneous users.
View 3 Replies
View Related
Jul 7, 2009
How do I setup a site to use two servers? One as a mysql server and the other as a web server.
At the moment I have the site on one server. When I get the second server what steps do I need to take to make this possible?
How do I secure the mysql server to only allow the web server to connect to it?
Do I need a control panel (i.e. cPanel) software on the mysql server?
View 14 Replies
View Related
Mar 21, 2007
here's my current setup has my stuff running on 2 separate "self contained" servers (eg; each runs their own apache/php/mysql):
Main site/server:
content: mostly static content (no mysql, very little php). currently has about 4tb/m traffic. in the summer it could push up to 6tb/m
hardware: P4 2.8ghz. 1gb ram. this server has no problem handling the load. only problem is bandwidth (i have to get it off the current host)
Forums site/server:
content: running vBulletin. currently 400-500 peak (probably jump to 800 peak this summer) users active per 15 mins.
hardware: 64bit dual Opteron 242. 4gb ram. it's absolutely griding that to a halt at peak times. it acts like 4gb memery isn't enough (it will run fine then eat through most of the 4gb. grind to a halt, then recover) personally i think it was setup/configured wrong but i've had multiple people look at it and nobody can find anything wrong in the apache/mysql settings.
What I want to know:
what type of server setup should I start migrating to? should I keep both parts of the site separate? eg; main site on one server, forums on another server(s)?
what i've sorta been looking into is 3-server setup.
(server1) main apache/php server. probably on unmetered (honestly don't think i'll find anything else that offers high enough traffic). run the main site and the vB php from here
(server2) dedicated mysql 'read only' server (server3) dedicated mysql 'write only' server.
and have mysql read/write synced and have all 3 servers networked directly together. i have a friend running a single mysql driven site using this setup and it works really well for him.
is this overkill for me? should the current dual Opteron be able to handle the forums and i just need to hire someone smarter, or is there some other setup that would work better for me? i'm tight so i want to go cheap as possible, but I also realize i need room for summer traffic expansion that always hits us.
View 4 Replies
View Related
Jun 29, 2007
Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
Two Dual Core AMD Opteron™ 2212
- 2.0GHz, 2X1MB Cache, 1Ghz HyperTransport
Two Quad Core Intel® Xeon® E5310
- 1.60GHz, 2x4MB Cache, 1066MHz FSB
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
View 14 Replies
View Related
Nov 18, 2008
Here is what I am trying to do, to set up a WordPress powered site to be run across two servers for load balancing. The two servers are dedicated and I have the load balancing software installed and set up. I need to set up the site so that both of them are accessed, but to also have the same content. The main concern is for the same content.
WordPress uses a MySQL database to place all of the content there, so the main thing I would need is to set up the databases so they are synched on both servers, so that the same content is showing up on both of the servers, and so I don't have to manually upload data to the database every few hours, that would suck. I have already found a script to connect to a remote mysql server, it is called HyperDB, but I was wondering if there are any better ways.
View 11 Replies
View Related
May 29, 2007
I currently have one server a
Dual Xeon 5130 2GHZ (woodcrest)
2GB Ram.
Running cPanel/WHM
Now I run a website that is VERY PHP & MySQL Intensive and MySQL is ALWAYS the top of the process list, hogging a ton of usage. It's getting to the point where the site is needed a second server and I know there's a few options; but I'm not sure which one would be the best.
They way I see it my two options are getting a 2nd server and setting up the two to do load balancing, or getting a 2nd server and setting one up for just Apache and the Other for MySQL and using the 2nd as a remote SQL server.
If I do the Apache on a seperate server would I need such a powerful server? And if I also would want to upgrade this server along with getting a 2nd server would I be better of upgrading to 4GB of RAM or upgrading the processors?
View 9 Replies
View Related
Jun 2, 2008
I'm running a message board and it looks like I've outgrown the low end xeon 3040 1.86GHz dual core server, and the bulk of the CPU load is going to mysqld. I'm debating between offloading the DB to a dedicated server vs upgrading the existing server and hosting the web server and db on the same machine.
Any thoughts on the better approach? fwiw, the load from apache seems next to nothing right now, but I am also planning on adding an SMTP server for user registrations and general support email.
I'm also not super familiar with dual-core and dual processor machines. Does shifting mysql to a dual core or dual proc machine help (vs a single core/single proc machine)? since there is just one mysql daemon, does having a second core or proc. buy me anything?
View 10 Replies
View Related
Jan 20, 2007
I have a lot of questions here so if you can't answer them all I understand. even pointing me somewhere where I could get the answers would be appreciated; hardware sites focusing on server hardware, forums focusing on such, etc.
we plan to have three different types of servers:
- db server (self explanatory. mysql. for forums, mysql driven sites.)
- file server (lots of files around ~2-10MB, consistant 70mbps right now, but we want more room for upgrades. needs a LOT of storage room.)
- web server (lots of php files, but also static things like plain html, images, etc. also includes all misc services for the setup-- dns, etc.)
could I be given a rundown for which hardware each of the three should have? I don't need specifics, even just knowing that more ram is important here while cpu doesn't matter as much, or that the fastest disks available are a must, etc would all be valuable info for me. despite that, I certainly wouldn't mind specific hypothetical hardware configs.
for the database server I'm assuming the more ram the better. not entirely sure about the cpu? also not positive on disks...
for the fileserver, how much ram would be practical or useful? disk io will be an issue I'm because plenty of people will be pulling files at once so the disk needs to read from multiple places. scsi (and even raptors) are not an option as we need 750GB+ of space on a reasonable budget. more ram will take some load of of the disks, but how much is neccessary / reasonable?
for the web server I'm assuming cpu first, then ram, but it'll likely need less ram than the db server?
I'm more lost on the disks than anything. scsi on the fileserver is not an option under any circumstances due to $/GB. for the db & web server I'm willing to pay for scsi if the performance increase really does warrant the extra money, but I'd like to be convinced before shelling it out. if you have benchmarks geared at server hardware when it comes to disks I'd really appreciate it.
also, what's the best way to network these together when colocated? each one with a dual gigabit ethernet port and then the communications go to and from the router?
View 7 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
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
May 24, 2008
We send mail to another servers but we cant recieve mails another servers. We can't recieve with webmail and outlook.
I look logs but there is no error and our ip is not in blacklist.
there is the error in our server
[url]
linux cpanel centos 4.6
View 2 Replies
View Related
Oct 11, 2009
I am just colocating servers and managing them myself, and renting services off of them. In the future I would like to start offering dedicated servers as well. I am wondering if many companies do this, or if its more of a general practice to just setup as a reseller? The worst part that comes to mind is thinking of how to do billing for the bandwidth per month. With my setup I would only be offering flat bandwidth packages (like 2TB a month) but even so, I cant think of anyway to automate it so WHMCS knows if they went over, if so, how much, etc.
View 6 Replies
View Related
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 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
Jan 17, 2008
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies
View Related
Jan 15, 2007
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View 11 Replies
View Related
Aug 15, 2008
What would give me the best performance, to have many low end servers (core2duo) or a few high end servers (quad cores, dual quad cores).
Running everything from mysql queries to video streaming.
View 11 Replies
View Related
Aug 13, 2008
Is it possible or advisable?
View 8 Replies
View Related
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
Mar 28, 2007
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
View 2 Replies
View Related
Jun 13, 2007
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 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
