04383: I cant import SQL backup of the whole database - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

04383	Bug reports	Import/Export	public	2010-06-01 14:28	2010-06-06 20:11

Reporter	desmedt	Assigned To	Mazi
Priority	urgent	Severity	partial_block
Status	closed	Resolution	no change required
Product Version	1.87+

Summary	04383: I cant import SQL backup of the whole database
Description	I try to import a SQL backup of the 'entire database'. My steps: I choose create or import new survey. I choose Select CSV/SQL file and select the sql-dump. then the import starts counting percentages. But there is no result and no error message
Additional Information	I cant attach the SQL-file, it's more than 12,000 k The MySQL table with the results got lost, so it's important to recover the backup.
Tags	No tags attached.

Bug heat	2
Complete LimeSurvey version number (& build)	1.87
I will donate to the project if issue is resolved
Browser
Database type & version	142
Server OS (if known)	win
Webserver software & version (if known)	win
PHP Version	PHP Version 5.2.13

User List	There are no users monitoring this issue.

Date Modified	Username	Field	Change
2010-06-01 14:28	desmedt	New Issue
2010-06-01 14:28	desmedt	Status	new => assigned
2010-06-01 14:28	desmedt	Assigned To	=> user372
2010-06-01 14:44	Mazi	Assigned To	user372 => Mazi
2010-06-01 14:49	Mazi	Note Added: 12052
2010-06-01 14:51	Mazi	Status	assigned => feedback
2010-06-06 20:11	Mazi	Status	feedback => closed
2010-06-06 20:11	Mazi	Resolution	open => no change required

Mazi 2010-06-01 14:49 updater ~12052	If you back up the entire database you can't just import this file to create a single new survey. You can either import the whole database by using tools like phpmyadmin or you can export single surveys as .csv and import them when creating a new survey. You can't import .sql files to create new surveys.