|
How do I get all data from one row from mysql table exported into text files, but formatted this way:
one field under another, one per line i would like to break that data into pieces and save for example 50 lines in file1.txt then next 50 in file2.txt...
Started by Phil on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
<? $row = mysql....
If you have a more specific problem is just too easy .
Into the PHP Functions of the
PHP Filesystem Functions and PHP: MySQL Functions
There are a lot of resources in the web how to control a MySQL Database via PHP.
|
|
I've copied the db3 database file on my Palm Pre to my computer and would like to convert it to a MySQL database (so I can print the memos). (Or, better, I'd like to find a GUI like PHPMyAdmin that can read the db3 file.)
How can I access that data on...
Started by Ari on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
There is a Firefox plug, I was just told, that can read a SQLlite file (which the Palm db3 file is): https be turned into a ....
Then you can get it to MySQL through ODBC.
Also MS Access can import db3 files.
To MySQL.
|
|
I'm wondering if it's better to use mysql or use files to store data? What is safer, what is faster? I'm talking about php and mysql.
Started by Donator on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
NOSQL databases like Redis are also an option.
If you are just talking about typing up some documents) .
There isn't to use MySQL or some other database.
Unless it is really trivial though, you may as well use mysql.
Depends on the data.
|
Ask your Facebook Friends
|
I'm at square one on a project that will need to repeatedly import data from MySQL *.dmp files into an existing Sql Server database. I am looking for guidance in the form of an existing tool, framework, or, barring pre-existing solutions, suggestions ...
Started by Rob Allen on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I think you should load all those data into new MySQL installation and then use SQL Server take a look at this document: SQL Server....
An application/script to walk the structure of the source database (MySQL in this case) and generate above.
|
|
/var/log/mysql/mysql-bin.log
Will it re-create?
Started by Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
If you don't want the ....
This is a binary log, which is used for replication transactions .
If you just move/remove it, you will probably be stuck with an open file handle that keeps getting written to, but you will no longer see the file.
|
|
Is there a command to determine which configuration file MySQL 5.0 is currently using?
Started by yalestar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
No such file or directory) stat64("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=4227, ...}) = 0 open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
So, as you can see..it lists the .cnf files, that it attempts to use....
|
|
Where can I find the include files for MySQL on Linux? I looked in /usr/include/mysql according to this but they are not there. My apache web server works fine with MySQL 5.1 up and running with PHP 5, but I can't find where the includes directory is!...
Started by deownefin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
mysql_config --include
On my system, this prints -I/usr/include/mysql
If the directory revealed by mysql_config doesn't have the right include files, your installation may have been partial or may have been altered after ....
|
|
How to restore one of my mysql db from .myd, .myi, .frm files?
Started by chandrajeet on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
(errno: 145 as long as it is the EXACT same version of mySQL and you have retained all of the associated files, /var/lib/mysql....
From MySQL: Database failed to execute query (query) 1016: Can't open file: 'sometable.MYI'.
|
|
Hi, I'm totaly new for mysql, I have phpmyadmin(cs4 mysql) on which i have to import the excel file. plz help me,thanks in advance.I dont want to use command line.
Started by amol on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If that doesn't work, we need a bit more information; maybe some example data from... .
Save excel file as csv, import csv via phpMyAdmin
Try adding a top row in the Excel file containing the corresponding columnnames in the MySQL table.
|
|
What would be the easiest way to take a Outlook pst file and export all of the emails into a MySQL database?
Started by Sam Hamilton on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Probably the easiest would be to open your PST in Outlook, and use
File->Import and Export, Export to a File, Comma Seperated Values (Windows)
This creates a CSV file , which you can then pull into MySQL via mysqlimport....
Yikes.
|
