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?
 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
 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.
 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. Smile
Geeklog Polish Support Team
 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