Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 10:08 am EST
Geeklog Forums
MemoSystem sql dump
Kiwi
Anonymous
its says to 'Last dump Memosystem.sql in to your database' and i have no idea how to do that. I searched google and found slight references to adding a .sql file to a databace in phpmyadmin , but i have cpanel and in my Mysql settings couldnt find anything that looked like it would let me do it.
Help please?
Help please?
8
7
Quote
Status: offline
ajzz
Forum User
Regular Poster
Registered: 01/19/05
Posts: 113
from the directory where you have downloaded the sql file, login to the mysql server using
> mysql -u yourusername -p
> enter your password
mysql> use geeklogdatabasename;
mysql> source filename.sql;
that normally works (cant remember if i used the semicolon)... your install may have a different syntax - type help at the mysql prompt to find out how to run sql from a file.
good luck
ajay
> mysql -u yourusername -p
> enter your password
mysql> use geeklogdatabasename;
mysql> source filename.sql;
that normally works (cant remember if i used the semicolon)... your install may have a different syntax - type help at the mysql prompt to find out how to run sql from a file.
good luck
ajay
6
9
Quote
Kiwi
Anonymous
how do i get to this prompt? like its not on my computer its on a remote server. i'll try SSH first then get back to you.
7
26
Quote
Status: offline
Robin
Forum User
Full Member
Registered: 02/15/02
Posts: 725
Quote by Kiwi: its says to 'Last dump Memosystem.sql in to your database' and i have no idea how to do that.
By any chance you have access to a wonderful tool like phpMyAdmin. There are two options for dumping sql into a db.
First: a window where you can paste the content of sql file
Second: you can load it from file, sql file.
If you "have no idea how to do that" get familiar with some GUI tools to mysql.
Geeklog Polish Support Team
6
13
Quote
All times are EST. The time is now 10:08 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content