I'm looking to import hundreds of email messages stored in mbox format into a MySQL database. Is there a tool out there to do this already? I'd rather not reinvent the wheel if at all possible. I've been using HyperMail to archive my email in HTML format, but the results aren't searchable. I figure that once it's all in MySQL I can write some simple queries to accomplish this.
View 1 RepliesI'm quite a newbie when it comes to MySQL but i heard that its possible to import data from a CSV into a mysql table.
Can anyone enlighten me on how to do it please? Im running CentOS and usiong MySQL Workbench to connect and run queries.
I have my CSV formatted so that the first row has the names of my columns on the table that I want to import it to and the following rows are the data that needs importing.
It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies View RelatedI am trying to install some program: rosinfo: - Create mysql database for rosinfo - Create table hosts, locks. Use file docs/rosinfo.sqlAnd I need to create table hosts, locks, using file rosinfo.sql. I have that file, but dont know what to do with it.
View 1 Replies View RelatedI want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies View Relatedi am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies View RelatedI am migrating SugarCRM from windows server to a linux server. But the main problem is the database. How will I import the data from MSSQL of windows to MYSQL of Linux ?
View 5 Replies View RelatedI want the LAMP server to present an upload page to the user The user uploads a zip file containing txt files which are tables in clear-text format The server : opens the zip validates the text files (going to skip this for now, but will try to make later) converts the files as here imports them to MYSQL tables All this is supposed to happen automatically, then the user can immediately use the website with the updated data How to implement this (esp. the first part with the zip file)
View 1 Replies View RelatedSpecifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies View RelatedI have installed MySQL server via Synaptic Package Manager successfully and I also installed MySQl administrator to check for MySQL installation. It is all there. And I ran this also, where "mysql" is a client tool:
hpng@hpng-laptop:~$ sudo mysql
[sudo] password for hpng:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I entered my ubuntu user password, and I get access error. I have 10.04 LTS version.
I'm looking for commandline monitoring tool for mysql and only thing I can find is mtop. Unfortunately, mtop's development halted back in 2004. Can someone suggest an alternative? or is there such thing?
View 2 Replies View RelatedI'm looking for a graphical database management tool that will allow me to create some tables and whatnot. I'm looking for an application similar to Toad: http://www.toadsoft.com/toadmysql/
Does anyone know of a similar program for Linux?
Managing MySQL servers can be quite complicated without a proper tool.I have used some commercial tools over the years, but I need something that is Web based, accessible from internet.There are NOT many offerings out there, so I wonder if, beside one company that launched a product quite recently (Novaquantum), there is something else out there that can I can compare it with?I guess when you find something that you like, you'll always to look for something better (PhpMyAdmin doesn't count!)
View 2 Replies View RelatedI am using MySQL version 5.1.47 (64bit) on Centos 5.5 in production environment. I am exploring option to monitor MySQL though SNMP traps. Can anybody please let me know if there is any open source SNMP tool that can be used for MySQL monitoring?
View 4 Replies View RelatedAs it says in the title I need to use the scalpel file recovery tool, or something similar to be able to recover a lost mysql storage folder.. The system crashed, and I really need these files as fast as possible. So I would love any help I could get.I have been searching in different search engines (including this forum) for an answer to my question, but I can't seem to find it.How can I configure scalpel, or any other similar application to be able to recover my mysql /var/lib/mysql storage directory. I really need these files... And.. I know, I should have taken backup
View 4 Replies View RelatedI'm using debian 5 x64 with xfce.Is there a way to configure (start/stop/restart) services (especially Apache2, mySQL and PHP) using a graphical or cli tool? I tried to use sysv-rc, sysv-rc-conf, rcconf and rc-conf in the terminal but Bash didn't find them (Although Synaptic show that sysv-rc is installed).
View 9 Replies View RelatedI have an email server running postfix and popa3d under Debian. I have mailboxes in mbox (single file) format per user in /var/mail/username. I had my own mailbox get too many messages so popa3d refused to process per a compiled in security / anti-DOS limit, so I moved to /var/mail/username_bak. What is the best way to start moving the messages from /var/mail/username_bak to /var/mail/username? I do not see any utilities included with postfix or popa3d that do this, but I am hoping there are generic mbox utilities to easily do this.
View 1 Replies View RelatedFor some time Ihave copied my email folders in .mbox format to files which I then can save to cd. Unfortunately, these files are one (very) large concatenation of email text+attachments which are very inconvenient when searching for a lost email. Question:how to backup emails from within Kmail? And, yes, I did read the Kmail manual cover-to-cover and found nothing relevant.
View 3 Replies View RelatedRecently, my hard drive crashed. I was using XP and do not have my install discs (lost them 3 moves ago...). I make backups regularly and only lost roughly 3 days worth of material (nothing really important). On my other PC I've been running linux forever. I don't need windows and have installed a new HD in the PC and put fedora on there w/ no issues. Now historical email. There seems to be many workarounds for getting dbx files to mbox inside windows, but how would I accomplish this task without a windows install anywhere (Virtual installs are out as I do not have any install discs for windows anyways).
After a quick search, I only found one possible solution (in perl) and am looking for something that I don't have to program my self. I am a programmer by trade but have never programmed in perl (c++, FORTRAN, matlab, python... yes) and at this point, don't feel like learning new syntexs for this one problem (python has been my goto scripting language for everything linux...). Also if anyone has a link to a c++ lib(link to documentation?) that does the same thing... I might take a look at that and make a gui for it... then release it for others...
I am looking for a locally hosted web based mail client that will work on Windows (Vista and up) as well as Linux. Right now, I use mutt (Cygwin mutt on Windows), but I was wondering if there was a simple web based client I could use. It does not need all of the fancy features of mutt, just the ability to send mail and allow me to browse my local mbox files.
View 2 Replies View RelatedI used Unison to sync my desktop and laptop. Now I am getting the following error when I open my Evolution Inbox (and a few of my other mailbox folders).
"Error while Opening folder mbox:/home/myname/.evolution/mail/local#Archive/foldername"
"column folder_name is not unique"
I have tried moving the .evolution/local/mail folder opening Evolution, closing and then moving back - no joy. It is also definitely not a folder size problem, my mailbox is less than 1GB.
Opening Evolution from the terminal I get;
** (evolution:7529): DEBUG: mailto URL command: evolution %s
** (evolution:7529): DEBUG: mailto URL program: evolution
[code]....
I tried using the advice in this thread (the only one I can find with a similar error):
[URL]
cd ~/.evolution/mail ; for i in `find . -name folders.db`; do echo "Rebuilding Table $i"; sqlite3 $i "pragma integrity_check;"; done However, I still get the problem. I'll paste the print out below as it is rather long.
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
after I had to rebuild the rpmdb because of some errors within it, i can't import any gpg-keys with the command "rpm --import". All I get is this:
[Code]....
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedMysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View Related