Import From Dump Files
I am trying to use a database in my dynamic web page setup but every time I try to restore a particular database in Mysql Administrator, I get the message
"The selected file was generated by mysqldump and cannot be restored by this application." I have read countless pages on this forum but even with the syntax generously provided I am still in trouble. I will provide some more detail to ensure I am not at fault with my syntax .
My database integrate.sql is in a folder for my downloaded files call it "downloads"
My Mysql setup in done in the default manner into the program files... path
My test local web site in a "integratewebsites" folder (in the windows default wwwroot folder of my c drive)
I want to restore the integrate.sql folder, I assume to the mysql default path (data) and point my web site there so I am not looking to move anything away from default locations. Can anybody help me with a sample command line please?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Can't Import Dump Files In Mysql 5
I apologize upfront if this is common knowledge. I've searched for quite a while and found nothing concrete. Using phpmyadmin 2.6.4-pl4 MySQL 4.0.23-nt php 4.4.4 When I export and make a sql file, I cannot import the data using this setup: phpmyadmin 2.6.4-pl4 MySQL 5.0.24a-community-nt php 4.4.4 Get "No SQL query!" message through phpmyadmin when I import the .sql file. If I cut and paste out the create table or insert text it works, but that takes forever. If I copy the data files to the data folder everything works in mysql 5. The sql files I've tried have been from 2-4 mbs. My backup dumps are 80 mbs though and obviously worried about restoring backups. Is there something I missed when upgrading? I pretty much copied off my data, uninstalled mysql 4 and installed mysql 5. Not in strict mode. Dataserver is in another location so can't always go copy the files off manually. Thanks for any help.
View Replies !
View Related
Dump Files
I have a dump file and I want to import into my database. I try to do this command in mysql consol(mysql.exe) source C:/file.dump; but d'ont work How can I do to work ???
View Replies !
View Related
Sql Dump Import
I'm writing a forum script. so i need an install script. so, it would be easy if i had an sql dump and let the installation import it. it connects to the db ok. I got this off a friend but does not work $fromfile = @file("pb.sql"); if(!$fromfile){ $main = "We could not read the SQL data from pb.sql"; } else { $queries = split("; ", implode("", $fromfile)); foreach($queries as $query){ if(!mysql_query($query)){ echo mysql_error();
View Replies !
View Related
Import Of Old MySQL Dump With Same Names
I dumped mySQL to a file, and want to IMPORT it to a new location (other host. I have the mySQL db already and it have the same fields/names in it, but I want to import the old ones (use them instead, because it contains text and info) When I run the RUn Quierys in mySQLAdmin I get error: allredy exist. Do I have to delete the existing first? how do I empty it then?
View Replies !
View Related
Import Files
I am looking for solutions to autmatically import text files into MySQL. Something almost like a queue. Files will be dumped from one machine, to a directory. I then need the MySQL box (separate server) to pick up that file and import it into the MySQL database. I'm not sure how to do this, other than writing a script and scheduling it to check the directory periodically.
View Replies !
View Related
Import Multiple Files
I have 5 clients uploading structured .txt files into a directory. Every day, there are about 2000 text files uploaded. I would like to import this textfiles every second with a cronjob. How can i automate this import without having problems with the different "file_xxxx_0123.txt" filenames ? How can i make the script select the oldest file in the directory
View Replies !
View Related
How To Import Ascii Delimited Files?
Is there an easy way to get an asci delimited data into a mysql database? I'm trying to use the USDA's food database but it's only available in MS Access and ascii delimited files. Is there an easy way to import either of these formats to mysql?
View Replies !
View Related
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
View Replies !
View Related
Import Original Database Files After Clean Install
I am wondering how to import database files stored on a seperate partition into a brand-new MySQL installation. I do not have the old MySQL installation because this is a clean install of XP. I have the actual database folders and table files (the ".frm" and ".opt" files) stored on a seperate partition which were created by a different MySQL installation. Is there a way to do this so the MySQL client will see them? I tried configuring a new datadir and copying the old MySQL data folders and files into the new datadir but that didn't work -- MySQL only sees the default databases created during installation.
View Replies !
View Related
Import Dump From Unix Mysql To Windows Mysql
I am trying to load a dump from a MySQL database on my ISP's server to my development environment on a Win 2K machine (running MySQL). When I run the mysql command to run the load script, MySQL gives the following complaint: "ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual t hat corresponds to your MySQL server version for the right syntax to use near 'D EFAULT CHARSET=latin1' at line 7" The dump from the ISP's server is created using mysqldump. The ISP is running MySQL 4.1.20. My development environment is MySQL 4.0.26. I have no problem loading dumps made from my development environment usng phpmyadmin.
View Replies !
View Related
Backup :: .sql Files OR .myd .myi And .frm Files?
my host went down and so I got backups. Well, what I received is the raw data and stuff, not .sql files. For what should be simple .sql files instead I have craploads of .myd, .myi, and .frm files. How do I put all this stuff together to get a single sql file so I can upload it into mysql and get my sites working again?
View Replies !
View Related
Dump Db
I'd like to set a cron job to do a db dump on a scheduled basis (for back-up purposes). I know how to work with cron, but am unsure of the commands to use to effect the dump.
View Replies !
View Related
Backup/dump From ASP
I am using a web hotel which is offering access to a MySQL database. The only way to make a backup is via a web interace. What I am looking for is a way to create a classic ASP script to get all the data, and send them in an e-mail. The e-mail part is no problem for me.
View Replies !
View Related
Shell And Sql Dump
Does anyone know where I can find information on how to setup my shell in unix/linux to allow me to restore a database from an sql dump... I have a database on 83200.mysql.com (example) that I have a file mysql.sql (also just an example). The file was produced using an sqldump command from a web interface... How can I configure a connection if I am not on 83200.mysql.com so that I can import the data into a database with a name of database_wordpress
View Replies !
View Related
Data Dump
I can take data into a database from an sql file with: mysql -u USER -p DBNAME < dump.sql But how do I send data out of an sql table, to an sql-type text file? Don't I simple change the redirection symbol from "less than," to "greater to," as follows: mysql -u USER -p DBNAME dump.sql Whenever I do this, however, it just hangs (even on tiny databases, so I must have something syntactically wrong here).
View Replies !
View Related
Dump File
I'm brand new to this and am trying to transfer a JSP site from one server to another. I think the only reason my site isn't working on the new server is that the sql database is not loaded on the new server. My hosting company told me I have to create a dump file and get that old info into my new database somehow. I've only messed around with the sqlmyadmin section and am not sure how to get this site going. I have the database that I FTP'd from the old site just sitting there named "load.sql" and can open it in notepad.Seems like a lot of random info but I have NO idea how to do this
View Replies !
View Related
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 !
View Related
Full Sql Dump
I have been using a front, and i have no knowledge of any type sort of command prompt. I am trying to upload my database onto my server host. The one i sent wont work.. so they told me to: 'to create a full sql dump that creates tables and records.' so can someone please please give me a step my step on how to do this?
View Replies !
View Related
Mysql Dump On XP
I am having terrible trouble trying to find out the right command to restore a mysql dump into mysql on my XP machine. I am trying to use both the windows command line and the mysql command line client, but I can't get anything to work! Been trying this: mysql databasename < databasebackupfile.txt And variations of with no success :-( I have checked the help file, and this is what it says to use. I am not a newbie to this, but I have never used mysql on windows.
View Replies !
View Related
Sql Dump File
278 meg dump and I cant figure out how to get it in to its new home on another server, errors out before any data is transfered. Locks up for 15 minutes and then errors out. How can I split this file and upload at the required size for mysql
View Replies !
View Related
Dump Database
I'm only interested in having a manually generated backup in the form of an SQL file containing a series of "DROP TABLE...CREATE TABLE...INSERT" statements, which I can reload if necessary. I can do this from within phpMyAdmin, but I'd really like to know how to do this myself from within my Apache/PHP-based website code on my home PC so that I can create the text file at the push of a button. I'm writing some PHP code to manage some date via a web interface. I can't seem to find in the docs exactly how to do this except from the server command line using mysqldump.
View Replies !
View Related
Dump Settings
A primary server is running mysql 4.1. The backup is running 4.0. I have a schedules dumb from primary to secondary occuring nightly. I just realized that the import to the secondary DB is generating errors due to: ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 Is there any setting in the primary db dump to dump the file for version 4.0? Or any other thoughts? We have anumber of things going on and have decided not to upgrade the backup mysql version just yet.
View Replies !
View Related
Dump To SQLite
I am trying to dump the data to import in SQLite. I used --compatible=ansi option. What is the correct syntax / options to be used with mysqldump for this purpose?
View Replies !
View Related
Restoring Xml Dump
i tried to restore a xml dump in mysql but got the following 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 '<?xml version="1.0" encoding="iso-8859-1" ?>
View Replies !
View Related
Restory A Dump
i'm having troubles trying to restore a mysql dump file with MySql Administrator. It's the dump of a genetic db downloadable from the db website but the file size is 6 gb and my system stops without any error message during the restore and doesnt go on. Is it cause the file is too big and MySql cannot handle it.
View Replies !
View Related
Mysqldump Never Dump
I am trying to dump an existing database data to a new database. I did the mysqldump: mysqldump -u root -p db2 < db1_backup.sql I did that, and when I go to mysql prompt to show tables, then select * from table1, I got no result. I am clueless what I did wrong.
View Replies !
View Related
Access Dump
In a previous post about a week ago a user said he created an sql text using accessdump. I would like to export my access database structure to mysql. Is this what the accessdump is? Where do I find it or what can I do in access to export this whole structure?
View Replies !
View Related
Importing Dump Using SSH
I have made a dump of a site using phpMyAdmin, and stored the dump as /httpdocs/myDump.sql.gz. I am trying to restore it using SSH with the following command: mysql -u myUserName -p myPassWord -h myHost myDatabase < /httpdocs/myDump.sql.gz and get the prompt: -bash: /httpdocs/myDump.sql.gz: No such file or directory when it clearly does exist. The main problem is that the host cannot allow you to create a new database via phpMyAdmin, so i have to import the dump using SSH. This means that the database i am trying to create ("myDatabase") doesn't yet exist - am i right in assuming the restore will create it (it contains the commands to do so)? Otherwise, what is going wrong?
View Replies !
View Related
MySQL Dump Help With Version ;4.0.14-log
Every time I try to do a back up of the databases on our system i get this error: ea990# mysqldump -u root -p --opt -full test > test.sql mysqldump: unrecognized option `--max_allowed_packet=16M' and it doesnt seem to dump anything, I have tried various options, and usually use my db back up script but that doesnt seem to work as well. ---- #!/bin/sh # mysql nightly dump PASS="xxxxx" DATE=`date "+%Y-%m%-%d"` /usr/local/bin/mysqldump --password=$PASS -A > /usr/home/http/mysql_dump/backup.$DATE /usr/bin/bzip2 -9 /usr/home/http/mysql_dump/backup.$DATE ------- but that gives me the same error as above.
View Replies !
View Related
Dump (quick) A Table Into Another One
On MySQL, I've got a table I use as 'wild card'. I mean, I store data into it and, at the end, I dump all the date into 'production' table. Until now, I perform it following these steps: 1) I empty 'production' table 2) I make a SELECT of every rows of the 'wild card' table and an INSERT into 'production' table. 3) I empty 'wild card' table. But I've got problem: during SELECT+INSERT time, 'production' table is not full and there's a data lack. I'm looking for a faster way. Does anybody know it? Thank you very much. PS: I was told about 'mysqldump', but I do not know if it's faster than mine.
View Replies !
View Related
How To Dump (quick) A Table Into Another One.
On MySQL, I've got a table I use as 'wild card'. I mean, I store data into it and, at the end, I dump all the date into 'production' table. Until now, I perform it following these steps: 1) I empty 'production' table 2) I make a SELECT of every rows of the 'wild card' table and an INSERT into 'production' table. 3) I empty 'wild card' table. But I've got problem: during SELECT+INSERT time, 'production' table is not full and there's a data lack.
View Replies !
View Related
Cannot Restore From Dump (phpMyadmin)
Using phpMyAdmin to export an entire database works fine - I get a mydatabase.sql file. Restoring (using phpMyAdmin) usually work fine. However, if any of the data in any of the fields contains the '#' character, it bombs out citing a syntax error. I have tried escaping the character with '' to no avail - still gives syntax errors. Seems strange that phpmyadmin dumps a file that will not restore...? I have tried this on several versions of phpMyAdmin and get the same result every time. Have searched for ages looking for a solution, anyone else experienced this?
View Replies !
View Related
Weird Characters After Dump
I used phpmyadmin to export a database into a file called file.sql, then from ssh I dropped the database, issued a 'create database dbname' command, then ran 'mysql dbname < file.sql'... The problem is now there are a bunch of weird characters being generated.. like  and †.
View Replies !
View Related
Foreign Keys :: On Dump?
I wonder if InnoDB is very buggy?! I often have problems adding or changing a foreign key on an existing database. But strangely if I export the whole DB as a dump and then I edit the dump so it adds the keys I need it works without any problems.
View Replies !
View Related
MySQL Dump Date
i am using mysql dump from an auto scheduled task. i need the date to be in the file name when i back it up. at the moment the existing files just get written over.
View Replies !
View Related
Mysql Dump File
I've got a file that has a load of INSERT INTO lines in it which I'm dumping into my database. This works fine but I was wondering is it possible to display a text output from this file. e.g. INSERT INTO table1 VALUES (1,'a'); INSERT INTO table1 VALUES (2,'b'); ## display 'Table2 entry finished' INSERT INTO table2 VALUES (1,'c'); INSERT INTO table2 VALUES (2,'d'); ## display 'Table2 entry finished'
View Replies !
View Related
Dump Backward Compatibility
I'm a complete newbie as you can see for my post count. I'm trying to use Props CMS (http://props.sourceforge.net/index.php) in order to build a small site for my school. I'm using Windows XP as development platform so I installed Apache 2, PHP 4.3 and MySQL 4.1, everything in windows flavor. The site is working great at the moment, but I recently asked to our host provider (where I will upload the site once it's finished) and he told me they use MySQL v3.23 (on Linux of course), and they cannot update to MySQL v4.1 at the moment. I've spent almost two weeks populating the DB with my school's info.I've checked out the system requeriments for running PROPS and it says MySQL v3.23 is just fine. So the question is, can I use a dump (from my 4.1 version) to populate the 3.23 version data base in my host's server?If so, do I need to use any "special" operator or something like that?
View Replies !
View Related
|
TRACKER
