freeoda.com Database creation issues

Hi guys

I used mysql workbench to export the db i am using on my pc at home. I am now trying to create that db on the freeoda website, so they say you must first create a db, then take the backup script, ie from Workbench i assume, rename to import1.sql and ftp it to their ftp site. I did all of that, but on the freeoda website, it does not look like you can create a db with your own name, because all they seem to allow you to do is click create db, and one with a name of their choice is created, so now i am thinking i have to create all the tables manually and insert data manually as opposed to my workbench script which does it all. Anyone else have issues with the db creation on freeoda? I want a db call Team_Management. Please tell me how you did it if yours works. I sent them a support mail ,still waiting for a reply.

Thanks guys

Hallo,

I have exported my database on my local computer. It creates then a filename.sql. Then I created a database with freeaoda's names. Then I logged into that database by using the numbers that was generated automatically during the database creation process. Then I open the empty database and import new tables from my filename.sql. It succesfully imported my tables with the old names. The only thing that changed was the databasename itself. So therefore we only have to change that in the connect.php file and use the include function and include the revised connect,php file. I hope I answered your question.

Van Zyl

Cool, thanks for the tip Van Zyl. Will implement it that way then.

Thanks also for the tip, wasn't really sure what to do.

Guys help please,

I am trying to read from above do not seem to understand, my question is, I am trying to export my database from my computer to a freeoda web hoster, using their mysqladmin, but it always tells me that I have syntax error on my query, I do not know what this whole thing mean... help me.

Thanks.

Did you copy your database to the root of their server ?

Yes I did, but its in a zip folder.

Could anyone please tell me a sequence to follow in, because I have just done everything(ftp uploading) from scratch, so I uploaded my database, in a zip folder, from there, what do I do?

Anyone please, I am so desparate to get this working by today so I can focus on other exams.

Thanks a lot.

And do you see a import1.sql file in the root of your folder now ? The important things is that your database must be exported to a .sql file, that file must be renamed to import1.sql and the import1.sql must be in the root of your server - you should be able to physicly see it there when you browse the root. Also, it is case sensitive.

Yes I can see it, and I imported my database and it said my order will be processed very soon...

Oh I just got a message and said import error

Guys thanks for the help, I am giving up, I will just create tables in their database and do everything from scratch, this thing it looks so difficult to hack.

Thanks @32237731