GoDaddy Importing SQL / CSV From Access
I am very new to MYSQL and have been forced to get serious about it. I had a fairly large DB in Access that I modified to match a new MySQL database. All the fields and tables are the same. I have tried to import CSV files through the SQL button at the top in MyPHPAdmin.
I called GoDaddy and they said that was not allowed and that I had to create a SQL file on my computer and import it that way.
So for the next couple of hours I downloaded MySQL Server(4.1) and MySQL Migration Toolkit. I got both of those to work and it went throught the migration perfectly.
The migration tool did several things. It created a table file for each in .frm format and then it also created a creates.sql and inserts.sql. It seems like the two sql files should be all I need.
I tried to import the sql files but I'm not sure where to do the import since I can't break the files into tables. Can someone give me some clear direction on what I could try next?
View Complete Forum Thread with Replies
Related Forum Messages:
Importing MySQL In MS Access
I'm building a shell script that store information in a MySQL 5.0 database. One of the data I store in the table is a text file. I use a BLOB type for this text data. If I try to import it in MS Access 2002 the BLOB column is converted to a OLE type, but when I try to open it in access I get this error: "A problem occurred while Miscrosoft Access was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access." I know that it's because MS access doesn't know what type of object it is and with which program it should open it. But I don't know how I can tell access the type of object it is. Should I create a module to handle these objects? I'm new to access databases so I don't know where I should start. If someone has any tips or codes I should use please le me know. Should I use another type instead of BLOB?
View Replies !
Importing Access To MySQL
I have a site that I want to change over from ASP / Access to a PHP / MySQL platform. My only issue is that the client uploads a new version of the Access DB every few weeks. I don't think they'd be able to upload it in any other format... so I'd need a way to import the .mdb file into MySQL.
View Replies !
Importing Table From Access
I've got a problem when I try and import a table into a MySQl database using MyPHP Admin and the Import CSV using LOAD DATA option. For some reason only the last record gets imported, although there are almost 700 records in the table. I regular import data into two other tables using the same method without problems, so I'm pretty sure I've got all the right parameters set up when exporting the original MS Access table as a CSV .txt file.
View Replies !
Importing Data From MSSQL And Access 97
I have a need to run a daily data gathering to pull information from three separate applications into a single MySQL database for reporting purposes. We are currently doing individual reports using iReport which works well, but I want to automate things - here's what I need to do: Import data from remote MS-SQL databases Import data from local or remote Access 97 databases Ideally, I want this to be a batch process running as one or more cron jons on a linux server (PHP or or PERL scripts?) rather than a GUI-driven exercise. I am looking at the various bridges from Easysoft but wondered whether there is a better place to start?
View Replies !
Importing To Mysql From MS Access-csv Options
I am having problem importing an Access 2000 csv into mysql using phpMyAdmin. I have set CSV options: fields terminated by {,} fields enclosed by {,} fields escaped by {don't know what to put here} Lines terminated by {don't know what to put here} Column names {don't know what to put here} the first row of the input file has the field names will someone tell me the correct parameters for this kind of input file?
View Replies !
Connecting A Database Using Godaddy
I have been tring to connect to my database using godaddy i keep getting an error#1064 you have an error in your SQL syntax check the manual that corresponds to your MYSQL server version for the right syntax to use near // connect to database $hostname = 'h41mysql47'.secure.net';
View Replies !
Transfering From Godaddy To Hostgator
I have been with godaddy for almost a year and my hosting is about up. I want to move to hostgator so I can have a cpanel and continue learning. I am having a horrible time getting my databases moved. There is a compatability issue. Hostgator went and converted all but one. I have two issues. I go to config my wordpress and it only works on the index but not the blogs in the site.com/thisfolder. Also godaddy emailed me this one database because it was not accessable to me user_45319205-11-07.sql "-- MySQL dump 10.9 -- -- Host: 10.0.11.206 Database: user_453192 -- ------------------------------------------------------ -- Server version4.0.27-max-log" This I guess is not compatable with hostgator how can I take this .sql and make it so I can put it on a database on hostgator?
View Replies !
GoDaddy MySQL Stuff
I have just finished making a large-scale project for a client of mine and when I went to move it over to his servers I got a little confused. He uses GoDaddy and their control panel is completely different than what I'm used to (cPanel 11)... so I need some help :P I have successfully transfered the database over but now I can't seem to connect to it... oddly enough? Do I have to use some different kind of php connection script to connect to their databases or something? Here's what I currently use: $dbhost = "h50mysql9.secureserver.net"; $dbuser = "user_here"; $dbpass = "password_here"; $dbname = "name_here"; $db = mysql_pconnect($dbhost,$dbuser,$dbpass); mysql_select_db("$dbname",$db);
View Replies !
Can Access Remotely, Cna't Access Locally (seems Backwards)
I have a database that I am trying to connect to a schema called lportal4_1_2 in mysql 4.1.13a (provided by my hosting company) runnning in fedora. I am trying to get a container to connect to it and was having problems. Since I didn't want to pollute the problem with the container, I wrote a small (hack) program that does the connection. Here is the problem: I can connect from my desktop (winxp) using a Java command line application, Mysql Administrator and mysql query browser and everything works fine. When I run the same Java command line app (using the exact same driver) I get the Access denied for user error that follows: ---- java.sql.SQLException: Access denied for user 'lportal'@'inkbrains.com' (using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)...........................
View Replies !
Can't Access Created DB's Via PHP, Though Can Access Them Via PhpMyAdmin
I can create databases via mysql-shell and edit them. These then do show in phpMyAdmin and are editable. BUT, if I try to access these db's via a normal php-script (i.e. $ergebnis=mysql__list_dbs($server)), it only shows me one database, the test-db. (To show them, I use a for-loop which counts the elements in $ergebnis from 0 to the number smaller than mysql_num_rows($server) and then prints the string.)
View Replies !
Cpanel Can Access But For Others Access Denied
I can access my database through Cpanel's GUI with no prob, but when I tried using MySQL-front in my comp, it always give me an error access denied. I supplied correct username and pass but still no luck. and How do I configure MySQL-front to connect to my webserver's mysql db?
View Replies !
Importing Db From 3.23 To 4.1
We were trying to restore version mysql 3.23 into mysql 4.1.1, but then all the conetent has become mix characters. I know that 4.1.1 is using unicode, but how can have my tables restore if I want to use version 4.1.1
View Replies !
Importing A DB
Suppose I've backed up a database using mysqldump. Now I want to import this database to a MySQL in another machine. The database name might be the same one as the original or something new. How do I do it?
View Replies !
Importing CSV
I am having problems importing data in to my table, i keep getting the same error Parse error: syntax error, unexpected T_STRING on line 64 here is my code: LOAD DATA INFILE 'csv/data2.csv' INTO TABLE company FIELDS TERMINATED BY ',' (company_name,comment,phone,fax,num_of_emp,website,physical_add);
View Replies !
Importing Sql Statements
I have a text file with about 90,000 insert statements (as below). Is there an easy way I can get these into my mysql database in one fell swoop? Can anyone tell me how and perhaps that the syntax is?
View Replies !
Importing With PhpMyAdmin
I want to import a csv file into my table. However, I need to empty the table before I do this. The problem is, I only see an option to "replace" the data. Is there a way to empty a table AND simultaneously import a csv? I know this is possible with the mysqlimport command (with the --delete argument), but I'm not if it's possible in phpMyAdmin. I'm using phpMyAdmin 2.9.0.2 and MySQL 4.1.10
View Replies !
Importing Headers
I have a text file with 180 headers. Is it possible to import this file into mysql where mysql will automatically create the table with column headings from the headers (as sql server and access do?) In case that doesn;t work, how can I create the table and past the header names into th command line, or use a text file to impoprt the headers in somehow? Last question, am I gonna be sitting there doing a 160+ field create table statement?
View Replies !
Exporting And Importing
I have been adding posts on a phpBB forum locally, and I have purchased hosting. I cannot acces the mySQL file, because i have to use a mySQL admin thing. I can import databases, but I do not know how to. If anyone can tell me how I can import and export a database, that would be great! O yea, and my database has tons of tables (29, i think)
View Replies !
Importing Dbase
Quote: CREATE TABLE IF NOT EXISTS `topic` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `topic` varchar( 50 ) default NULL , `alphabet` varchar( 1 ) default NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1360; MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1360' at line 6
View Replies !
Importing A Dump
I'm having a problem when trying to import a .sql from MySQL 4.1.7-nt running on a windows XP machine to a MYSQL 3.23 running on a Red-Hat linux machine. When i run the "mysql -u Username -pPassword 'DB_name' < file.sql" , i get an error : "ERROR 1064 at line 20: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6 " Now i'm quite new to Mysql but i'm wondering if its not a backward compatibility problem. I'm able to import the file fine on my Windows machine and am able to import a dump from the 3.23 server without problems.
View Replies !
Importing A Very Large DB
I have a rather large .sql dump that I was given to work with thats about 3 gig. I cannot get a smaller .sql dump unfortunately. I am using wamp server on my local machine and importing this database will take forever. I have two questions...... Can I optimize the amount of memory or processor dedicated to php or mysql to speed this up? Is there a way to add some sql parameters to the import to only import parts of the database I am working with? One of the columns is a unix timestamp which would also solve my problem.
View Replies !
Importing CSV Into PhpMyAdmin
trying a very simple import of a CSV file into my MySQL DB using PhpMyAdmin. I've done this before, but i forget how it worked last time! anyway, after i do the import it has an error, something like: 'INVALID FIELD COUNT ON LINE 2' it always manages to import the first line. I've tried to alter things but cant figure it out.
View Replies !
Importing From CSV File
I have a pretty small CSV file with 12 columns and about 150 rows. Some of the fields have names which have commas in them like this, John R. Smith, Jr. So I can't use commas a delimiter. Excel adds "" around the field swith a comma or period in them. What can I do to get around this and bulk import this data into my table?
View Replies !
Importing Old Data
I hope everyone can give me some guidance. I know the description of my problem is pretty vague, but I'm sure ppl have encountered this before. So I'd just like some general tips.I had a database. Now I redesigned the database, with InnoDB annd foreign key support. I know this is better and I have a good design.Trouble is, how can I convert my old data from my old MySQL database to the new one? The columns are different, and how do I handle the FK?
View Replies !
Importing One Field
I have a question for you all. I have a MySql database with over 20,000 records stored in it. Under a table, there are 20 fields, and i want to import data from external CSV into that field only, the rest of the fields & Tables stay the same, and i can't figure out how to do it
View Replies !
Importing 5MB Database
I am new to MySQL and my skills really on extend to importing and exporting using phpmyadmin. I have a database I need to import which is around 5MB and the import limit on the server is around 2MB. Extending the limit is not an option. I have tried to import using ssh and get the error saying the database already exists. I tried deleting the database and running the command again I then get the error of restricted access to blar@localhost etc. I then tried using a php script called BigDump, I set it up as instructed and got the same error - MySQL: Can't create database 'copperfieldwines_com_-_cart'; database exists. I'm thinking I need to edit the MySQL dump but haven't a clue what to do.
View Replies !
Automating Importing Csv
I'd like to be able to run an SQL to read a flat csv file into a blank table. This is so I can manipulate the table and import it into my real database. Is there a simple script available to do this?
View Replies !
Importing Database :: How To?
I backed up my database yesterday and it saved it to a csv txt file. I had to reinstall my store and database and can't seem to get the import to work for the file. I am using myphp for my database
View Replies !
Importing A .SQL Into Databases
I'm trying to upload a .sql file for a program of mine that says I need to import it into the database I created for it. But the thing is using the source (.) command then the file name doesnt seem to be working I will type the name in and it always gives me this message. mysql> . antrix.sql ERROR: Failed to open file 'antrix.sql', error: 2 I always get this error. And I can't figure out why. But all I know is when I open the file without the sql tryin to import it. Where I just open it with notepad it gives me the things it does for the tables and so on. But it would take me weeks or so to put all that information in. So I wanted to just add it in by importing so it wouldn't take forever.
View Replies !
Importing Csv Data In
Ran into a problem importing a txt file (csv) into mysql. I performed this command: select * into outfile '/whatever/path/whatever.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by ' ' from <tablename> and it exported fine and we were able to put it into another database (access) without a problem. But if I take the same file and try to load the text (csv) back in to mysql, it gives warings and only half of the data is loaded (more info to come). here is the command I am using to bring it back in: mysql> load data local infile 'whatever.txt' into table <tablename> fields terminated by ',' optionally enclosed by '"' lines terminated by ' '; now, I have a hexdec number being generated inside brackets as the last column and I have a feeling its causing the problems here as it looks like this in the textfile: "{3C0E0712-74C5-BA7B-B296-3B23C3F76EC6}" but looks like this in the database after I import it back in | {3C0E0712-74C5-BA7B-B296-3B23C3F76EC6}""350893020 | And shouldn't it look like this? | {3C0E0712-74C5-BA7B-B296-3B23C3F76EC6} | After checking, its combining the last and first columns of 2 consecutive rows into one column. The 350893020 should be the first thing in the next row of data. Works fine when I don't use " as the optionally enclosed by from going to sql to sql but causes problems with date/time format in Access so I can't really export it without the " marks.
View Replies !
Importing From MS Excel
Wondering how best to get data from some MS Excel tables into mySQL ... understand there is some software/shareware that can expedite this process.
View Replies !
Field Importing
I need a bit of help with importing data. Basically. I am exporting some data out of the a table called 'authuser' and the field called 'uname' I can export it into CSV, SQL etc etc. Then i am trying to just import the data from uname to a table called 'accounts' and the field called 'user_name' I have manual after manual, searched the internet ... and yet cant find how to do this. When i import, it sets up a new table which is called 'authuser' which i dont want. Is their any way to do this?
View Replies !
Importing CSV With Parameters
1. if the entry is already in the DB and nothing has changed, skip it 2. if the entry is not in the DB, insert it 3. if the entry is in the db, but with updated information, update it but record a comment about what changed (comments stored in separate table) 4. if an entry is in the DB, but NOT in the csv file, update status to "removed" I'm currently trying to work with load data infile, but it's producing all kinds of headaches when I then try to fulfill the other parameters. Any ideas on what the best way to accomplish this is?
View Replies !
Importing Sql-file
I'm trying to make a database and a user and importing an .sql-file. I use the next commands: mysql > CREATE DATABASE tomdb; mysql > CREATE USER 'tom'@'localhost' IDENTIFIED BY 'tomsql'; mysql > GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'tom'@'localhost'; when i then try this from the terminal: mysql -utom -ptomsql tomdb < TomBackUp01032009.sql I'm getting ERROR 1044 (42000) at line 21: Access denied for user 'tom'@'localhost' to database 'tomdb'
View Replies !
Importing Table
i have a large dump of user table which has a password field containing hashed password (used mcrypt for encryption) when i import the dump using command line only the passwords get corrupted.
View Replies !
Importing Dates
How do you get it to import if the text file has different date formats. specifically MM/DD/YY and MMM DD YYYY example 06/22/05 and Jun 22 2005 ?
View Replies !
Importing A Database
I have a client who I am doing some work for. They use MySQL. Having installed MySQL, they sent me a CD with data files on. All these data files are of the format *.MYI, *.MYD and *.frm. Looking at my existing databases, these files seem to be the index, data and ? files for their tables. I copied these files into my /mysql/data/<database name>, and expected to be able to open up My Query Browser and see all their data. However when I click on the database name, I get this error: Could not fetch Schema Tables MySQL Error 0 Has anyone got any idea of what is going on here? I've looked through all the manuals and the website but can't seem to find anything relating to this.
View Replies !
Importing A .sql File?
I have very little experence with mysql. i receved a backup file from my ISP of the db i was using. (filename.sql). I just installed mysql 5.0 on a server here and want to import this backup file to the server here. Is there step by step directions for doing this ? or can some one help my import the file.
View Replies !
Date Importing
I'm using Load INFILE function, but I have dates that are formatted mm.dd.yyyy in a tab separated text file. Example: order abcdef 10.05.2004 They do not import. Using Navicat to check, date is 1/1/001 Tried changing field type to: date datetime timestamp I added the following line to my.ini: date_format=%m.%d.%y This did show up in MySQLAdmin. BUT, date is still
View Replies !
Importing .txt Files
i have a backup .txt file of my older databases that i want to import that into MySQL. I have been using phpmyadmin but that says it will only accept txt files up to a Max: 2,048KB, but this txt file is about 7mb. Ive tried zipping it and importing that but i get " Error in ZIP archive: File is encrypted, which is not supported from this class.". How can i import this txt file into MySQL? Whether thats through using the Mysql console or phpmyadmin.
View Replies !
Importing New Data
I'm working on a business directory site that I created using phpmydirectory. All of my business listings data was imported into mysql database from the admin area of my site. My categories are stored in the "pmd_category" table. This table has ID, Title, Description, and Keywords fields. At the time that I imported my business listings, I left the Description and Keywords fields for each category blank. I am now wanting to go in and add descriptions and keywords to each category. I have roughly 400 categories. I think I will have to use PhpMyAdmin in order to do this. I would like to setup a simple spreadsheet and fill in the description and keywords for each category, and then use import in PhpMyAdmin. Is this possible? If so, how would I set it up? Am I making sense? I really don't have much experience with PhpMyAdmin. I can browse around and export when I need to, but I'm scared I'll screw something up if I try to update a table.
View Replies !
Importing Xml Into Mysql
I want to import a xml file into a mysql database. My xml file look like that: -<root> <dir for="informatie" name="root"> <dir name="Informatie generals" subtitle="opening .." prio="3"> <item id=195 accepted="true" prio="7" lastupdate="3DDB58D" lasteditor="john"> <title> Open a address</titel> <datumin>06-02-2003</datumin> <body> <!CDATA[ <strong> Is that my body file ... ]]> </body> </item> <item id=196 accepted="true" prio="7" lastupdate="3DDB58D" lasteditor="john"> <title> Open a address</titel> <datumin>06-02-2003</datumin> <body> <!CDATA[ <strong> Is that my body file ... ]]> </body> </item> </dir> </dir> ..................... </root> I want import this data like that: data from <dir> I want to put into a table "directories" with fields: id, id_subdir, name, description... and data from <item> into another table "items" with fields: id, id_dir, name, description, body, date_in, date_out .
View Replies !
Importing To Mysql
I have 2 text files in comma delimited format. One has customer numbers and one has corresponding items. I want to import this into a new database that I have created. I want to be able to match the customer number to items from the text files but I want my new db to assign auto numbers to the customer and items. customer and items are separate tables in my new db.
View Replies !
Importing A Db Into A Localhost
I'm trying to test out my database driven php pages on my local machine (IIS with MySQL 4.10) and obtained a dump file from my online host saved as db.sql I am trying to use the mysqlimport command like this at the mysql cmd line: mysqlimport --local localhost C:/db.sql (where C:/db.sql is where i placed the dump file and "localhost" is my own IIS machine) and there is not any importing.
View Replies !
Importing Spreadsheet
I have an Excel spreadsheet with almost 2000 rows of data and I was hoping that there was a way that I could you phpMyAdmin to import that data iwhtout having to type in each and every item? I have 2 other spreadsheets which have a total of about 7-8000 items in them as well I've been trying to follow the manual online and I have another book that I'm using but maybe I'm just being a bimbo because I can't figure it out I have already set up the table and fields in phpMyAdmin and I actually started to type the items in (about 200 so far) and I decided that was a little retarded considering that the spreadsheet was already there and I shouldn't need to...
View Replies !
Importing Cvs Into Mysql
i downloaded the freebie geoip database from maxmind but this comes in csv format. phpmyadmin only accepts sql files for import. im probably overlooking something ... ?
View Replies !
|
TRACKER
