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.)
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.
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick
when i click "Email Accounts" section in Helm see "Failed to get Email Accounts",also cant add any new Email Account, Helm Log:
Cannot create ActiveX component. at Microsoft.VisualBasic.Interaction.CreateObject(String ProgId, String ServerName) at MailEnable.Administration.Mailbox.GetAutoResponderStatus() at WHA.Helm.Providers.MailEnableProvider.MailEnableEngine.GetAccount(String name) at WHA.Helm.Providers.MailEnableProvider.MailEnableEngine.GetAccountList() at MailEnableProvider.ListEmailAccounts(ProviderData CommandData) ......
In Helm, how do I establish a temporary URL for a client to publish with FrontPage before flipping their DNS from their old host to the new one? I'm new to Helm, but I don't see the controls. My reseller support is DOA for the past 6 hours.
We are planning on offering Windows hosting soon, and are in the process of testing possible control panel options. Has anyone had experience with both of these? Which one did you find "better"?
We don't need a billing system, as we already have one - so the billing system within Helm would not be used.
I am investigating options with respect to a VPS. I am looking for a provider that is extremely reliable, uses Windows 2003, HELM and offers MS SQL databases as well.
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server.
The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method.
Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?
what steps procedures need to be done to keep your database as safe as possible from the hackers. Anyway to be alert when someone got into your db and try to dump, alter your database?
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.
It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.
I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.
I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.
All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.
I just added an hourly crontab so as to restart the MySQL server as a stop gap.