Front-end To Create Reports And Queries, And To Load Data Into The Database
I've been trying to find a freeware front end to the MySQL database to
create reports based on queries, and some sort of front-end which I can
format for other users to use to load data into the db. Is there anything
out there for those functions?
View Complete Forum Thread with Replies
Related Forum Messages:
Extract Data And Create Database:
I'm working with this webpage (PHP/MySQL solution) locally and I'd just want to ask if there was a program that could extract all the tables and data from this local database (fx. to an SQL string) which I then could use to recreate the database on the server? I reckon I can't just copy the database, or?
View Replies !
Extract Data And Create Database
I'm working with this webpage (PHP/MySQL solution) locally and I'd just want to ask if there was a program that could extract all the tables and data from this local database (fx. to an SQL string) which I then could use to recreate the database on the server? I reckon I can't just copy the database, or?
View Replies !
Front End And Database Help
Can someone recommend a good front end for mysql. I want something like a switchboard from microsoft access,to make a interface to meet HCI needs(user friendly interface) I would also like some feedback on the work I have carried out so far on my first database. I want to create a database using mysql that can be used at a after school computing class. The database should be able to be used at the class. The tables that I have so far are student: all student details teacher: for the 2 different teacher group: Each student will be allocated a group ie beginner ,inter ,advanced class location: the locations and times the classes take place. attendance table: Need help on this The databse should have the basic featire like add ,edit, view ,search for students and also be able to monitor attendace for classes. for example on saturday a class will take place. Students arrive for class, the teacher is able to search for specified date and then get the group list for that day. He can then take a register to monitor attendance. Can someone help me with the details needed in that table. Am I missing any tables and can someone help with the field required in the attendance table.If someone has some time can they create a basic mysql database to monitor attendance. ie member , attendance table.
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
What Front End For Office Database / Web System
I would like to replace our current MS Access database with a linux based system. Our needs are as follows : A database to store our pertinent data A means of accessing the data from within our office (forms, reports, etc) A method for our clients to access our data from their offices ( ex..a web based access to our database) I am currently in the research phase, soon to be followed by the "learn a new language(s) phase." So I am a blank slate at this time, any recommendation is possible. How would you recommend I proceed? What structure, what languages, etc.. I have started reading about PHP with MySQL, would that fit the bill?
View Replies !
Load Data Infile :: Load Key
My question is this I need to load a file (b/c of the size I don't want to use insert statements) with load data local infile. The problem is I need to add a static value to each record created by the load that will serve as the key. In version 5 of MySql this is no problem because I can use set w/ load data infile to accomplish what I need. However I need to do this in an older version. Any thoughts on how I could pull this off?
View Replies !
LOAD DATA INFILE To Import Data Exported From A MS Access Xp
I am trying to use LOAD DATA INFILE to import data exported from a MS Access Xp table. But all i get in the date field is 00:00:00, as Access exports DATE and TIME and MySQL seems to use just the TIME portion of this. Is there any way to ahve MySQL import just the DATE portion or is there any way to have Access export only the DATE portion?
View Replies !
How To Export Data From Phpmyadmin Into LOAD DATA INFILE Syntax
I have a table with a lot of data (several millions of records). I would like to export the data using phpmyadmin into a SQL file. I know that phpmyadmin has an export feature. I need the exported data to be in the LOAD DATA INFILE format after the export. Is there a way to achieve this? Regular export uses the INSERT INTO ... syntax for the data.
View Replies !
Importing Data :: Load Data Warnings
I'm trying to import some data into mysql using the "load data" commands. Everything appears to work fine but in all cases I get loads of warnings (on 125000 records I managed over 1 million warnings) - is there a way to see at least some of those warnings? Also in one case (again 125000 recs) I am told 177 are deleted - is there a way to identify which ones and why?
View Replies !
Interacticve Reports
I have been searching the internet for a tool that enables me to create interactive reports from MySQL queries. I found many tools taht makes me do that, however none creates interactive reports. All I need is a simple table with the results of the query nothing fancy. The main thing is to be Interactive to refllect new dataase updates.
View Replies !
Crystal Reports
I've written a stored procedure that I need to use in a Crystal Report, but it will not show up as a datasource in Crystal. I've checked to make sure the SP is in the proc table in mysql. I've had speculation that the ODBC driver is not sophisticated enough to enable the SP to show up in Crystal. I'm using MySQL ODBC 3.51 Driver. Does this sound feasible? Has anyone had a similiar issue? Then I tried just using table joins in Crystal, but I apparently have too many left-outer joins, so I get an ODBC error
View Replies !
MySQLDump And Crystal Reports
Very new to MySQL. Been tasked with taking a backup of a MySQL 4.1.13a Database which is used with Crystal Reports. I have never used MySQL commands before but looking around it seems i can use the mysqldump command to take a copy of the database. If this is correct, the question i have is will this drop the tables from the DB as i want it to carry on as the Crystal Reports DB and also do i run it with the ---quick argument?
View Replies !
Reporting Software Like Crystal Reports
Got any recommendations for some software that can handle table as large as 800,000 records with joins to other tables to produce a time base report e.g. weekly slices of data. I guess you could say is similar to reporting a sales table but with thousands of transaction per week. I need a cheap solution about $100 USD. Software: PHP 4 or 5 + MYSQL on Windows XP
View Replies !
Integrating MYSQL And Crystal Reports XI
I have successfully created an ODBC connection with my MYSQL database remotely. The issue I am having is that Crystal Reports XI does not see any of my tables in the database. I have MYSQL 5 running on my server and I want to build reports of my database using Crystal. I have searched everywhere for answers and wanted to try this forum first to see if anyone had the answer.
View Replies !
Less Queries Or Less Data
is it better / faster to have rows that hold more data, (ie putting in a varchar username instead of an integer userID to save having to query another table to get the username) or is it better the other way around? (of course unless the username could be changing which in this application the username cannot be changed)
View Replies !
'LOAD DATA'
Environment: Windows XP - german settings. MySQL: 5.0.18-nt Database charsets have been changed from 'latin1' (where 'LOAD DATA' worked fine) to utf-8 to resolve some charset issues with Perl/Tk. When loading a csv-file to the data base in the new utf-8 environment and an 'Umlaut' appears within a field the rest of the field including the 'Umlaut' gets truncated. Because the csv-file was created under Windows I used the 'SET NAMES'-directive: SET NAMES 'latin1'; LOAD DATA INFILE '.....' INTO TABLE .... The "SHOW VARIABLES LIKE 'character_set\_%'"-statement displayed all charset-variables are set to 'utf-8'.
View Replies !
Load Data
how to insert the values in different tables from the text file ? means i have a text file.In that text file ,there is some data for different tables.I want to insert that datas into different tables.
View Replies !
DATA LOAD
I am using MySQL (5.0.51b-community-nt) DATA LOAD command. My table has multiple data types and my flat file has fixed width column. FLAT FILE DATA Ex: ....
View Replies !
LOAD DATA Odd Failure
Using this code from phpMyAdmin 2.5.6-rc1 : LOAD DATA LOCAL INFILE '/tmp/phpcqKlrN' REPLACE INTO TABLE `pics` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY ' ' Results in both fields in the text file going into the first field in the table .In other words a row of data in the text file (a record) ends up smushed together in the first field of the MYSQL table. Text data looking like "ford", "red" ; ends up looking like ford","red - I've tried variations ... Text file is off a windows machine , going into my ISP's linux machine ...
View Replies !
Load Data Infile &
I am building a web app to load data into MySQL db from an uploaded file. When using LOAD DATA INFILE, if I do not use LOCAL, does a client (viewing my web page) need to have any MySQL client components installed locally? I guess not if all processing takes place on the server, but I just thought I'd double check. Also, is there a way to manipulate data inserted with LOAD DATA INFILE, say I want to remove all special characters from strings before loading data. And finally, is there a way of mimicking Oracle's translate function in MySQL?
View Replies !
Load Default Data
I've read that mysql's LOAD DATA INFILE is up to 20 times faster than an insert query. If I need to load a client's default configuration into a table, I could use only this query, but now i need to load the defaults and other identification data from php into some of the fields. Which method would be most efficient?Making a full insert query with the default data and the identification datausing LOAD DATA INFILE and then updating the identification fields with an UPDATE querywrite the default configuration data and the identification data to a file and then use LOAD DATA INFILEperhaps another better approach that I don't know of
View Replies !
LOAD DATA LOCAL
i have to reconfigure mysqld to allow the LOAD DATA LOCAL command to work. i've read all the docs and still can't figure it out. all i want to do is import a cvs file into a table.
View Replies !
Updating Load Data
Is it possible to do an update with load data infile? We need to load a load of csv files into our database but the tables have additional fields over the ones in the csv files that we need to preserve as they contain the margins and profits for each item.
View Replies !
LOAD DATA SYNTAX
I'm looking for a smooth method to update our webdatabase regularly. At the moment we are using LOAD DATA INFILE..., with CSV data, but sometimes the process will run forever (copying to temp table or something like that). I think anything went wrong during the process and he cannot go on. The load in this state is very high, so that the db is useless. Does it help to give "LOAD DATA" the option "LOW_PRIORITY"? By the way, I'm in an argument, is there an "HIGH_PRIORITY" statement for "LOAD DATA", I don't think so and also nothing found about that.
View Replies !
Load Data - Is This A Bug Or What Did I Wrong?
I'm using MySQL 5.0.27 on Windows. I'm not sure whether this is a bug or if I do something wrong. Hence, I'm posting here. I think it's a bug - but one never knows. I made up some test scenario. It consist of this datafile c:lb.csv --- 1,0f10 2,0f20 3,0f30 4,0f40 5,0f50 --- and this script --- create database if not exists load_bug; use load_bug; create table if not exists lb ( i int not null primary key, s varchar(20) unique not null ); load data local infile "c:lb.csv" into table lb fields terminated by ","; select i from lb where s="0f10"; --- The set remains empty. select * from lb; gives: +---+-------+ | i | s | +---+-------+ | | 0f10 | | 0f20 | | 0f30 | | 0f40 | | 0f50 +---+-------+ Furthermore, if I reverse the sequence of i and s in the table everything works as expected. If I add another data element (j int) it works too.
View Replies !
Load All Data Files
The more I play wth mySQL, the more questions I have... I have a folder with 500 text files. Each is a flat file database with 33 lines [fields]. I would like to consolidate this data by importing it all into mysql so the contents of each file is one record in the new database. Just for good measure, I'd like to include the file name as the key or primary field.
View Replies !
LOAD DATA :: Nothing Loaded
trying to load a text file (.csv) into MySql. I created a database; a table and the requisite fields. The text file and MySql server are both on my PC. I then tried using the following: load data local infile 'e:filename.csv' replace into table database.tablename fields terminated by ',' enclosed by '"' lines terminated by ' ' ignore 1 lines; The command runs but nothing is loaded.
View Replies !
Can't Load Data From File
I have just installed MySQL and I am trying to load data into a table, but whenever I try to to this I get ERROR 2 <HY000>: File 'C:Program FilesMySQLMySQL Server 5.0datamenageriepet.txt' not found <Error 2> What should I do?
View Replies !
Load Data Does Not Work?
mysql> CREATE TABLE table1 -> ( -> id_table1 int auto_increment primary key, -> name_first varchar(30), -> name_last varchar(30) -> ); Query OK, 0 rows affected (0.03 sec) mysql> LOAD DATA LOCAL INFILE 'c:/Program Files/MySql/MySql Server 5.0/data/da .txt' INTO TABLE table1; Query OK, 2 rows affected, 6 warnings (0.00 sec) Records: 2 Deleted: 0 Skipped: 0 Warnings: 4 mysql> select * from table1; +-----------+------------+-----------+ | id_table1 | name_first | name_last | +-----------+------------+-----------+ | 1 | NULL | NULL | | 2 | NULL | NULL | +-----------+------------+-----------+ 2 rows in set (0.00 sec) Data has two rows of lastname and firstname Why is it showing null in the column values?
View Replies !
Load Data Command '|'
EXample File .txt 1|30/04/1999|5051000002|0.0|5.0|0.0|51.0|1.0|-144.21|-144.21|5.74|1.0|migracion|0.0|50.0|50.0|AXN|15:38:27|03/05/1999| 2|30/041999|5051000004|0.0|5.0|0.0|51.0|1.0|-270.24|-270.24|5.74|1.0|MIGRACION|0.0|50.0|50.0|AXN|15:38:28|03/05/1999| How import from load data command?
View Replies !
Load Data Command
Okay real dumb question, i have a test file that looks like this: "Name","Address","City","State","ZIP","Phone","BusCode","BusOrRes","SolicitFlag","BusType","Last Name","First Name","Middle Initial","Suffix","Secondary Name","URL" "Adams P","7901 W 52nd Ave","Arvada","CO","80002","303-424-2529","","R","N","","Adams","P","","","","" "Albright Christine","8020 W 52nd Ave","Arvada","CO","80002","303-583-7734","","R","","","Albright","Christine","","","","" "Albright Eric","8020 W 52nd Ave","Arvada","CO","80002","303-583-7734","","R","","","Albright","Eric","","","","" "Aldinger Ronald W","8520 W 52nd Ave","Arvada","CO","80002","303-420-9354","","R","N","","Aldinger","Ronald","W","","","" and when i try to load it into my table, and use the fields terminated by ',' it imports the quotes too. in foxpro, loading text into a table drops the " " around character fields automatically so im a little stuck, i also tried '","' but it drops the first characters on the fields when it imports it.
View Replies !
Load Data Error
I am a newcomer of mysql. I installed it on windows. I am studying the manual of it and encountered a problem when doing : To load the text file pet.txt into the pet table, use this command: mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet; I created a pet.txt file under mysqlXXdata folder, but i do not know how to load it into mysql. and always get ERROR 2 (HY000): File 'pet.txt' not found (Errcode: 2)
View Replies !
LOAD DATA Output
I have a batch file that logs into a MySQL database, and then calls a script file that loads a csv file into a table. I pipe the output into a text file, but the text file is blank after I run. The LOAD worked as I see the records in the table. Does LOAD DATA output anything? What I am looking for is something like "5 records added to table" inside an output file. Is this possible?
View Replies !
LOAD DATA In MySql 4.0
I'm getting an error running LOAD DATA on server running version 4.024 MySql. I know it's part of 4.11 (it's in the documentation). Does anyone know if it is supported in 4.0?
View Replies !
LOAD DATA INFILE
we are having a multi language website. There are two files responsible for the german and the english version. Now I wanted to change this to a database driven version, so I can check if the translation already exists etc... So I built a table with five fields: Code: id constant lang_de lang_en area Next I took the (modified) german language file which looked like this: Code: _CITY","Ort _COUNTRY","Land _FON","Telefon and did a a load data infile with mysql: Code: LOAD DATA INFILE '/tmp/_language/german.txt' into table language fields terminated by '","' lines terminated by ' ' (constant,lang_de) SET area = "Test"; Now I need to do the same with the english language file, but I dont want the constant field to have dublicates. Thus I want to ADD the equivaltent english phrase into the lang_en field.
View Replies !
Backslash In Data/query And Like Queries
mySQL 4.0.20a WIN32 Need help with backslash syntax/like queries.. Query1: select * from dbtable1 where Filespec like 'http://www.10291.com/%' returns : http://www.10921.com/sikhnet/register.nsf/ram/radioG2/$File Query2: select * from dbtable1 where Filespec ='http://www.10921.com/sikhnet/register.nsf/ram/radioG2/$File' returns 0 records Query3: select * from dbtable1 where Filespec like '%\%'; returns 0 records What am I missing here....?
View Replies !
|
TRACKER
