Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...).
Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
View Complete Forum Thread with Replies
Related Forum Messages:
Graphical Interface Hangs When I Try To View Conents Of Table
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
PhpMyAdmin: Export Table - Import Table
I find in PhpMyAdmin where I can export a table, however when I click the "GO" button where is the exported file? And how do I name it? When I go to import a table I can select the file to import and that makes sense. My goal is to take a table from one database and use it in another database, so I hope I am in the correct place?
View Replies !
How To Export Db Or Table Structure?
We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content, on a separate machine. I know I can do a show tables on the existing db, and also a describe on those tables, so I know what the table structure looks like. I am trying to avoid having to re-type the create table statements for each table. Is there some kind of export command that will export that info to a file without the contents of the tables themselves? The current MySQL server version is 3.23.2-alpha-log. It is running on SunOS 5.6 (i386). If it matters, the new box will be a dual proc linux server, probably running RedHat 6.x or 7.x. We want to start with an empty database on that box.
View Replies !
Export Just Table Scheme
Was looking for some help within the MySQL adminsitrator that i can just export table schema's, with their values. I am on a shared host, so it won't allow just to create the database from my export statement.
View Replies !
How Can I Export A MySQL Table With A Different Name Using Phpmyadmin?
How can I export a MySQL table with a different name using phpmyadmin? I want to export nuke_bbsearch_wordmatch and all it contents to phpbb_search_wordmatch This table in a different db. Fields are the same just the name needs to be changed. When exporting. I have been editting the rest of the table I need manually bt editting them in notepad but the table 4 columns and has 170,000 entries. Example: I need to change entires like these 170,000 times INSERT INTO `nuke_bbsearch_wordmatch` VALUES (4146, 192, 0); to INSERT INTO `phpbb_search_wordmatch` VALUES (4146, 192, 0);
View Replies !
Export The Attributes From A Table To A File With A '&' Between Columns
I would like to select all the attributes from a tables and store it in a file .. SELECT * INTO OUTFILE test.txt FIELDS ENCLOSED BY '&' FROM table After each attribute i would like to add a Symbol '&' between them in the File.But i find that the tabs are also inserted between them and i do not want them in between . Does anyone know how could this be solved.The result wht i get looks something like this &0& &dslab467& &sonia& &SS07& The result how it should look like is 0&dslab467&sonia&SS07 does anyone know how to work it out
View Replies !
Export Table Data For Mass Labels
My goal is generate large lists of mailing labels that are based on: Name Address City State Zipcode I created the table and fields, implemented a submission form, and incorporated a link for an admin to download the data into Excel but thats as far as I got. Is there a better or more thorough approach? I believe that in the end, I want to download this into Word so I can do a mail merge.
View Replies !
Trouble With Export Of Access Table Into Mysql
I exported some tables out of access into mysql and I cant edit and records under mysql root account through mysql's query browser. I can edit from mysql command line using same credentials while working localy on the mysql server. Wondering why Query broswers Edit button is greyed out.
View Replies !
Phpmyadmin Export Problem With Order Of Table Creation
This is a phpmyadmin question more than anything, but I hope someone may be able to help. When creating a dump of a normalized database with 26 innodb tables, phpmyadmin export seems to only export the table structure/data in alphabetical order, rather than FK contraint order. Thus when importing the dump of the data, I need to manually go through and select the order to make sure the constraints hold up. Has anyone else seen this? I'm running phpmyadmin 2.5.4 on both linux and win xp.
View Replies !
Export MySQL Rows, Leave Out Command To Create Table
I am changing servers and I have a table with 500,000 rows. I exported the first 100,000 with the table information. The table is now setup on the new server with the first 100k, but now I need the other rows (100K at a time). When I try to export, I always get table data, to create the table again. How do I tell PHPMYAdmin to just export the rows to insert into the table, and leave out any command to create the table again?
View Replies !
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back. Has anyone heard of anything like this?
View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
View Replies !
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.
View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
View Replies !
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db. Example: I have a table with {id, url, desc} The program must generate a page with text fields to enter this information.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Replies !
Export To CSV
I need to extract a query result to CSV. Currently I have to get the hosting provider to run the query for me "SELECT ... INTO OUTFILE ..." and then email me the file. I can only access the mysql server via the command line utilities from another remote linux box (our webserver). Ideally I would run a command on the web server which would create the file locally (on the web server) so that I can then grab it via ftp. Can I do this with any of the mysql utils? If not I can just write a script to run the query and output it in csv format to a file but it seems silly to do that if one of the utils already supports this.
View Replies !
Export DB
i am attempting to export a DB so i can migrate a site from one server to another. However everytime I export the DB and load it into the new one, the new one says 0 bytes / queries.
View Replies !
Export
I am looking for a way that i can export the create table commands for the tables in my database to a text file so that i can copy and past them to my website in order to simplify the "create table" process.
View Replies !
Sql To Do CSV Export From MySQL
Does anyone know what sql would generate a CSV file from MSQL? As instructed by the help file I've tried; CREATE TABLE tablename ( tabledefinition here) ENGINE = CSV when I execute this sql I get 'No database selected'! If this would actually create the table I should then be able to; INSERT INTO tablename SELECT remaider of sql select statement here.
View Replies !
Script To Export
Does anyone know of a php script that I can use to put on a page to allow the user to click a button to export all tables in csv format ?
View Replies !
Phpmyadmin Export
This is a phpmyadmin question more than anything, but I hope someone may be able to help. When creating a dump of a normalized database with 26 innodb tables, phpmyadmin export seems to only export the table structure/data in alphabetical order, rather than FK contraint order. Thus when importing the dump of the data, I need to manually go through and select the order to make sure the constraints hold up. Has anyone else seen this? I'm running phpmyadmin 2.5.4 on both linux and win xp.
View Replies !
Export Into A CSV File
Is there an export equivelant to MySQL's "LOAD DATA INFILE"? I would like to be able to export a table into a tab delimited or comma delimited file for download. I tried looking through the MySQL online manual, but have not had any luck.
View Replies !
Export Data From One Db To Another Db
I have two mysql databases, I want to extract data from one table (ost_staff) in database1 to table (tickets_reps) in datebase2 The fields the table ost_staff are staff_id,firstname,lastname,email,username,passwd,signature,group_id The fields for table tickets_reps are ID,name,email,username,password,signature,user_group you will notice that firstname,lastname are combine in the table ticket_reps under field username In the past I would use INSERT INTO tablename SELECT * FROM db1.dbo.tablename but the table names and the merger of fields has me lost
View Replies !
MYSQL Export Help
I am running mysql 4.0 What i need to be able to do is, every night run a script to download new data (say from the last 24 hours), preferably in tsv or csv, and ftp the new file out. I have been able to create a file of the mysql data succesfully using OUTFILE but I need to create a new file with date and time in the name every day, so that every day a new file is created.
View Replies !
|
TRACKER
