Welcome, Guest. Please Login or Register.
August 26, 2025, 11:51:42 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  MySQL Upload? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: MySQL Upload?  (Read 354 times)
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
MySQL Upload?
« on: March 21, 2002, 07:11:57 PM »		 Reply with quote
How can I upload my yabbse.sql datafile with PHPmyadmin?

Ive tried loading it it and running it, but that dont seem to work.

any ideas?
Logged
To the world - you are just one person, but to one person you are the world!
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:MySQL Upload?
« Reply #1 on: March 21, 2002, 07:18:53 PM »		 Reply with quote
If you have telnet, try and use that to upload it.  Or break up your sql file into smaller ones.
Logged

My Amazon Wishlist
My Blog
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
Re:MySQL Upload?
« Reply #2 on: March 21, 2002, 07:23:09 PM »		 Reply with quote
how would i do that? sorry to sound dumb!
Logged
To the world - you are just one person, but to one person you are the world!
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:MySQL Upload?
« Reply #3 on: March 21, 2002, 07:29:12 PM »		 Reply with quote
Um...cut and paste :)
Logged

My Amazon Wishlist
My Blog
andrea
Global Moderator
YaBB God
*****
Posts: 4400


Peace on Earth

WWW
Re:MySQL Upload?
« Reply #4 on: March 21, 2002, 07:29:15 PM »		 Reply with quote
Are you trying to restore a db backup or are you trying to install YaBB SE?
Logged
Andrea Hubacher

Download smileys here - please follow the TOS - bitte Nutzungsbedingungen beachten
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
Re:MySQL Upload?
« Reply #5 on: March 21, 2002, 07:33:32 PM »		 Reply with quote
I have just reinstalled Yabb 1.0.0

I have a datafile that is data and structure.... i need to get uploaded, so I can then upgrade the board to 1.1

I have tried cutting and pasting, but it keeps telling me that the table exists and errors!

Am I doing something silly?

Tony.
Logged
To the world - you are just one person, but to one person you are the world!
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
Re:MySQL Upload?
« Reply #6 on: March 21, 2002, 07:51:16 PM »		 Reply with quote
should i delete all the tables - then run the query?
Logged
To the world - you are just one person, but to one person you are the world!
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:MySQL Upload?
« Reply #7 on: March 21, 2002, 07:54:42 PM »		 Reply with quote
Yes.
Logged

My Amazon Wishlist
My Blog
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
Re:MySQL Upload?
« Reply #8 on: March 21, 2002, 08:04:08 PM »		 Reply with quote
ive done that, but now get the error

Error
SQL-query :  

CREATE TABLE `boards` (
  PRIMARY KEY  (`ID_BOARD`)
) TYPE=MyISAM

MySQL said:


A table must have at least 1 column
Logged
To the world - you are just one person, but to one person you are the world!
Coyote
YaBB God
*****
Posts: 702


I love YaBB SE!
Re:MySQL Upload?
« Reply #9 on: March 21, 2002, 08:27:11 PM »		 Reply with quote
nevermind, ive done it......


I realised the top table create statement was wrong, so I copied that bit from the install yabb.sql


thanks guys
Logged
To the world - you are just one person, but to one person you are the world!
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  MySQL Upload? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.108 seconds with 16 queries.