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 RepliesI 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 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 RelatedDoes anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?
View 6 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 Related1. Am i able to host a MSSQL DB and use it on MySQL?
2. Where is the download link for MySQL server on Linuix (CentOS) as i can't seem to find it for linuix and is it possible to have a gui for MySQL on it if so which program would you recommend?
I'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.
i 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'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 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 RelatedI 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 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]....
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
I am running openSUSE 11.2 and would like to connect to MsSQL using PHP5.3.0 (I do connect to MySQL 5.1.45). Lots of info is available on the Google but nothing on SUSE. I installed "freeTDS" and "PHP5-PDO" objects but am not sure which way to go. Is ODBC another option? speed/functions?
View 9 Replies View RelatedI have been using Suse since version 6, now I installed 11.4 64bit - great distro, but still have no PHP5-MSSQL support. Why is that? FC supports it, why not Suse?
Is there, maybe, a current 64bit PHP5-MSSQL RPM from custom repository?
Workaround: Is there another way (or even different ways?) to connect to MSSQL server from PHP and if yes
On my LAMP server (recently installed, latest CentOS) i want to use php-mssql to connect to a remote MSSQL server. Therefore i need php-mssql. If i run "yum install php-mssql" it tells me "No package php-mssql available.".
On a older installation (2 years old, but up2date) i had no problem installing php-mssql. I cant tell the difference. I've read this tread:
[URL]
Also "yum install --enablerepo=extras php-mssql" didnt helped me.
I am relatively new to the world of linux and PHP. I need to set up my PHP to work with the extension mssql as I have a mssql DB on another server that my websites connects to. I have followed this guide [URL] but get the following error when I run the command isql -v mstest satest satest which is under step 5.
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
I just succesfully installed Centos 5.5 64bit with following package:
- httpd 2.2.3-43
- php-mysql 5.1.6-27
- mysql 5.0.77-4
and all these packages are running ok.
My question is how do i connect from Centos to another MSSQL server using PHP? I had read several article but cannot find the best way to achieve this because most of the instruction seems to be quite complicated. I found somewhere in this forum that all it need just this simple command: "yum --enablerepo=extras install php-mssql freetds". While others article said that i need to install "FreeTDS" and some ODBC driver. I'm a little bit curious since most of that article are using an older version of Centos and PHP.
Can we get this built into the distribution? This would really set it apart from other distributions that don't have this included. And it would most likely make a lot of PHP developer lives a bit easier.
View 7 Replies View RelatedI get this error when running my program under linux; under windows it works as expected:
Code:
$ ./mssql_test
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
qGetStringData: Error while fetching data ("[FreeTDS][SQL Server]Program type out of range")
QVariant(int, 1) QVariant(QString, "")
I can retrieve int's just fine, but not nvarchar's. I'm using unixODBC 2.2.12 and FreeTDS 0.82. The funny thing is, that I can use isql and tsql with no problem. The mssql_test program:
Code:
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QDateTime>
#include <QDebug>
#include <QVariant>
#include <QStringList>
#include <QSqlRecord> .....
The same error and output continue for the next records. These have cut out. I've been looking for a solution of a couple of days now, with no luck.
How to add port of MSSQL(1433) to httpd_can_network_connect_db or add some changes in apache policy? I know about httpd_can_network_connect but this is not my way.
View 6 Replies View RelatedI 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.
I don't know. I have had tons of issues with the Linux today. Now when I try and start mysql it just fails. the syslog says code...
The command mysql results in:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have even tried to uninstall mysql and reinstall it an nothing works. Any suggestions?
I'm trying to start my MySQL server, and it fails if the /etc/mysql/my.cnf file is there. If it isn't, then it fails - syslog shows me this:
Code:
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
[Code].....
I have probably found a bug in the Ubuntu php5 package. At first I thought it's a problem with Zend Framework, which I use, then I thought it's a php issue, but now it seems to be a problem with Ubuntu's php packages. My problem is that under certain conditions, php is going to read records from the mysql database table infinite times. For a much more detailed description of the bug,[URL]..
I've tried on an x86 Ubuntu Desktop edition, and an x64 Ubuntu Server edition, both 10.04, and both had this bug. I have set up a test system (x86 Ubuntu Server edition 10.04), and compiled apache2 and php5 from source, but used the mysql-server package from the repository. And I couldn't reproduce the bug. However, after copying the self-compiled libphp5.so file from the test system to the desktop that produces the error, I could still reproduce the error on the desktop. This suggests me that the problem is either not in php, or - more probably - there are multiple php binaries used in the repository version, and therefore it doesn't matter that I've copied my libphp5.so because mysql functions are somewhere else. I've found a mysql.so file in /usr/lib/php5/20090626+lfs coming from the php5-mysql package. Does that have anything to do with this issue?
ive been trying to fix this for a while. i dont have the original my.cnf, but i dont even know if thats the error:
Code:
pavel@pvl1:~$ sudo service mysql start
^C
pavel@pvl1:~$ cd /var/log/[code]....
Is there a php,mysql built in?What folder do i put my website?What command do i need to use to start and stop apache?If there isnt php,mysql built in how do i install it ?
View 9 Replies View RelatedI have trouble with MySQL server on my Ubuntu 11.04.Below is what I get in Terminal
root@linux:/home/karl# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the
service(
[code]....
I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.
View 1 Replies View Related