Welcome! Log In Create A New Profile

Advanced

Error when importing to freeoda.com

Posted by 50638459_Leolee 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Error when importing to freeoda.com
May 08, 2013 11:46AM
Hi Mac,

I seem to be getting an error. I exported my database onto my local computer, I seem to be getting an error when importing to the freeoda database. Please help, I'm getting frustrated. Here's the error:

Error

SQL query:

--
-- Database: `team_management_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `fixtures`
--
CREATE TABLE IF NOT EXISTS `fixtures` (

`fixture_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`opponents` varchar( 50 ) NOT NULL ,
`date` varchar( 6 ) NOT NULL ,
`venue` varchar( 50 ) NOT NULL ,
PRIMARY KEY ( `fixture_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =6;



MySQL said: Documentation
#1046 - No database selected
avatar
Mac
Re: Error when importing to freeoda.com
May 08, 2013 03:10PM
No, do not ask me.... ask in general. Also use formatted code button when posting code.

It says no database selected? You need to import the table into the database created by freeoda.
avatar Re: Error when importing to freeoda.com
May 13, 2013 08:42AM
Things to check:

1. Make sure the exported database is a .sql file and not something else like a csv or comma delimited file.
2. The exported database needs to have a specific name, I can't remember exactly now but I think it was import1.sql
3. This import1.sql needs to be uploaded to the /root of your server.

Once that file is on the root of you server the import function should find it automatically
avatar Re: Error when importing to freeoda.com
May 13, 2013 08:44AM
Never mind, I see in another thread that you got sorted smile
/doublepost :-o
Sorry, only registered users may post in this forum.

Click here to login